The purpose of the Pareto Chart is to address the most important among a set of factors, the highest occurring type of defect, the most frequent reasons for customer complaints, and so on. It combines an ordered bar chart and a line chart. The items on the left side of the chart are called the “vital few” while the rest are considered the “trivial many”.
This template comes in three variations. The first one is used when you have data that has been summed up or aggregated. The other two are used to record weekly and monthly data day by day. Once you have collected the data using a printed form or a check sheet, you need to enter the data into the worksheet. If you find in the resulted chart a Pareto pattern, this suggests that only few causes account for about 80% of the effect.
This template is a Microsoft Excel document that you can use and modify to best suits your needs. It can easily be modified to include additional sections if needed. For example, you may want to add additional rows to the worksheet to show more categories. Please help us to make this template better by providing us with your comments or suggestions.
Pareto Chart (24 KB)
Pareto Chart Template Example (24 KB)
Pareto Chart – Weekly Data (24 KB)
Pareto Chart – Monthly Data (24 KB)