Write “Category” in a cell and “Value” in the cell next it (of course, you can use the words you want, as “Defect type” and “U$S”). Below them, enter all the categories and their values. Select the whole range (including titles). Go to Data ==> Sort. Make sure that “My list has header row” is checked. In “Sort By” selct “Value” (or the word you used) and check “Descending”. Click “Ok”. Select the whole range again and click on the “Cahrt” button in the toolbar (or go to Insert ==> Chart). Make sure that “Column” is selected as chart type, and that the top left sub-type is selected. Click “Finish” button.
There is a little more to it than the previous post if you want to see the “bend in the knee”. You could do a Google Search for “Pareto In Excel” and the 6th link down titled “To Create a Pareto Chart” is a link which details it step by step.
Since it is not advertising a product for sale I will include the actual web address and hope they don’t edit it out. http://gsep.pepperdine.edu/~fmadjidi/To%20create%20a%20Pareto%20Chart.html
Any problems email me at home at firstname.lastname@example.org and I’ll send you the link
An alternative process to produce a similar chart to Minitab would be as follows:
Select (Note, if data analysis does not appera in the drop down list, first go to and select )
Choose select your data ranges (discrete categories in one column, continuous data in the other) in the
Check mark , , and
Choose where you want the Output to go (pick a cell on existing worksheet, select a new worksheet ply or a new workbook.