The following Pareto chart templates are ready to use, and the instructions below are available if you need help.
Pareto Chart Excel MAC
Pareto Chart Excel
Instructions
1. Sort your data in descending order. You should have two columns of data at this point – one column for the cause categories and another for the values of each category. Values can be counts (like this example), dollars, or whatever unit of measure is appropriate for what is being studied.
2. Open the Excel file and go to the Data tab
3. Enter the cause categories in the first column of data, which is column B on the spreadsheet.
4. Enter the values in the second column, with is column C on the spreadsheet.
5. Erase any rows that are not needed. The chart will be automatically populated.