How to create a Pareto chart
A Pareto chart is a bar chart that helps identify the most important problems or issues by visually representing their relative importance.

-
What it shows
A Pareto chart shows the frequency of different levels of a variable, with the most frequent levels at the top. The length of each bar represents the "cost" of each cause, and the bars are arranged in descending order. -
What it's based on
Pareto charts are based on the "80/20 rule", also known as the Pareto principle, which states that 80% of effects come from 20% of causes. -
What it's used for
Pareto charts are used to help identify the most important issues, prioritise problems to solve, and understand data distribution. They are often used in total quality management and six sigma methodologies. -
How it's used
Pareto charts can be used to help companies identify common defects, prioritise fixes, and identify top-performing products. -
What it's not used for
Pareto charts can only show qualitative data that can be observed, and they can't be used to represent quantitative data. They also don't provide solutions to issues, and they only focus on past data.
How to create a Pareto chart
1. Navigate to the area that you wish to add your Pareto chart
2. Open the 'Data' tab and either manually add in your data or copy and paste any data into the data grid. Your Pareto chart will automatically update.
3. Navigate to the 'Description' tab and click into the text field to add help context about your chart.
4. Update the title of your chart