Instructions for Pareto Chart Using Microsoft Excel 2007 | MGMT 403, Study notes of Introduction to Business Management

Download Instructions for Pareto Chart Using Microsoft Excel 2007 | MGMT 403 and more Study notes Introduction to Business Management in PDF only on Docsity! Instructions for Pareto Chart using Microsoft excel 2007 1. Create table. Information must be in decending order. 2. Create a column chart hi-lighting selected data. You should come up with something like the following 3. Select total percents in the legend. Once selected, right click and select the “change chart type option. Change the type of chart to line chart. You should now see something like this. 4. Now reselect total percent and go to the lay out tab. 5. Select format selection 9. Now select numbers. And go to design tab and select the option where the bars touch. It should be layout 8. Your graph will look like this 10. Select your total percents again so they are all selected. Then right click, and select “add labels”. Your chart should now look like the following. 11. The only problem now should be that the bars are the same color. To correct this, select each bar, and select format data type, then go down to fill, and select solid fill. Then change the color of the bar