Pareto Chart Template

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 graph. The left vertical axis represents the frequency of occurrence, while the right vertical axis represents the cumulative percentage of the total number of occurrence. 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 a combined data. Once data is collected using printed forms or check sheets, you need to type the data into this Excel worksheet. The other variations are used to record weekly and monthly data.

This template can be modified for your own use. For example, you may want to add additional rows to the worksheet to show more items. Please help us to make this template better by providing us with your comments or suggestions.