A Pareto chart ranks problems from largest to smallest and draws a cumulative line across the top. Most guides stop at "find the 80% mark." That is where useful analysis begins, not where it ends.
The cumulative line tells you which causes account for the bulk of the effect. But it does not tell you which causes cost the most, which ones shift over time, or whether the threshold should be 80% at all. This guide covers how to build the chart, how to read it past the obvious, and where it fits alongside other problem-solving tools.
What a Pareto chart shows
A Pareto chart is a bar graph with frequency on the left side (y-axis), percentage on the right side (z-axis), and contributing factors arranged in descending order by frequency on the x-axis. The bars represent individual categories of a problem (defect types, complaint reasons, failure modes). The line running across the top accumulates each bar's contribution as a running total.
Three elements make a well-constructed Pareto diagram: the contributors ranked by magnitude, the magnitude of each expressed numerically, and the cumulative-percent-of-total effect of the ranked contributors.
The chart is used to identify the most frequently occurring defects, the most common causes of defects, or the most frequent causes of customer complaints.
Where the 80/20 rule comes from
The principle behind the Pareto chart predates the chart itself by decades.
Vilfredo Pareto (1848 to 1923) observed back in 1895 that a relative few people held the majority of the wealth (20%). He developed logarithmic mathematical models to describe this non-uniform distribution. It was an observation about economics, not quality.
The jump from economics to quality management came through Dr. Joseph Juran. He was the first to point out that what Pareto and others had observed was a "universal" principle, one that applied in an astounding variety of situations, not just economic activity. In 1937, Juran added the cumulative line at the top of the chart and coined the terms "vital few" and "trivial many" to categorise the factors based on their weight.
The Pareto Principle is now recognised by the American Society for Quality (ASQ) as one of seven basic quality tools for process improvement.
How to read the cumulative line
When the cumulative line reaches 80% or above on the chart, all of the previously added-up factors represent the "vital few" causes. The bars to the left of that point are where focused effort will produce the most return.
That said, the 80/20 split is a rough guide about typical distributions, not an exact figure, and the numbers don't always add up to 100%. The split varies by context.
Real-world data shows this clearly. In one set of business examples: the top 15% of customers accounted for 68% of total revenues, while the top five products accounted for 75% of total sales. In manufacturing: in a 25-step process, five operations accounted for 65% of total scrap; of 12 services offered, three accounted for 82% of customer complaints.
The ratio is 65/5 in one case, 82/3 in another. The principle holds. The exact numbers do not. If you are waiting for a clean 80/20 split before acting, you will wait indefinitely.
How to build a Pareto chart step by step
The six steps to build a Pareto chart are:
- Define the problem and scope. Decide what you are measuring (defect types, complaint categories, downtime causes) and the time period the data covers.
- Collect and categorise data. Record every occurrence and assign it to a category.
- Summarise each category by frequency or impact. Count the occurrences per category.
- Order categories from highest to lowest. The largest bar goes on the left.
- Calculate cumulative percentages. Add each category's percentage to the running total.
- Construct the bars and cumulative line. Plot bars against the left axis (frequency) and the cumulative line against the right axis (percentage).
Data quality determines whether the chart tells you something real. Categories must be mutually exclusive, data collection should be objective, and labels should follow a consistent naming convention. If "scratches" and "surface damage" both appear as separate categories for the same defect, the chart splits what should be a single bar into two smaller ones, and the vital few shifts.
Most organisations build Pareto charts using Microsoft Excel, Google Sheets, Power BI, or statistical software like Minitab. SimplicityHub's Pareto calculator lets you paste your data and generate the chart directly in your browser. If you want a reusable offline version, the Pareto chart template works in Excel or Google Sheets, and the quick Pareto log template gives you a ready-made collection sheet.
Frequency-only vs weighted Pareto chart
A standard Pareto chart ranks categories by how often they occur. A weighted Pareto chart plots both frequency and a second measure such as cost or severity, and it can completely change the priority order.
This matters when cheap, frequent defects sit alongside rare, expensive ones. Considering both cost and frequency gives a better understanding of your cost of poor quality (COPQ). Minitab gives an example: even though wrinkles may be more frequent, they are less expensive to repair than dirt specks, which are a rarer occurrence. The biggest bar on a frequency-only chart may not be the biggest problem.
| Frequency-only Pareto | Weighted Pareto | |
|---|---|---|
| Ranks by | Count of occurrences | Cost, severity, or other impact measure |
| Best for | Initial problem identification | Prioritising by business impact |
| Risk if used alone | May chase frequent but low-cost issues | May overlook quick wins with minimal data effort |
| Typical use | First pass, complaint triage | COPQ analysis, resource allocation decisions |
Run the frequency-only chart first to see the landscape. Then build a weighted version before committing resources. The order of priority often flips.
Where the Pareto chart fits in DMAIC and Lean
A Pareto chart is used in the problem identification phase and in the data analysis and outcome evaluation phase after an intervention. In DMAIC terms, that places it in the Measure phase (to quantify the problem) and the Improve/Control phases (to verify the fix worked).
The chart also applies to outcomes you want to keep. If a process is performing well, a Pareto chart can identify the vital few contributing factors that must be maintained to sustain the desired outcome. This is the less obvious use, and it is just as valuable. Knowing what drives your best results protects them when conditions change.
In Lean and Kaizen, the Pareto chart shifts organisations away from broad corrective actions toward focused, high-leverage interventions. Instead of running a general "quality improvement initiative" across twelve defect types, you work on the three that generate 80% of the scrap. The tool narrows the target. Other tools, such as affinity diagrams and root cause analysis, then dig into why those three defects occur.
Common mistakes that make a Pareto chart misleading
Short data windows from unstable processes. Data collected during a short period from an unstable process may lead to incorrect conclusions, because the vital few problems may change from week to week. If your process is not in control, the chart reflects a snapshot, not a pattern. Collect enough data to cover the natural variation before drawing conclusions.
An oversized "Other" category. If the "Other" category is too large, revisit the raw data and break it into specific sub-categories. A large "Other" bar hides the very causes you are trying to find.
Treating the biggest bar as the automatic priority. The tallest bar is the most frequent category, not necessarily the most important one. Without weighting for cost or severity, you may spend months reducing a high-frequency, low-impact defect while a costlier problem persists in a shorter bar further to the right.
Ignoring small problems that are easy to solve. The 80/20 rule directs attention to the vital few. But a small category that takes five minutes to eliminate is worth doing now. Do not build a bureaucracy around the Pareto chart that prevents common-sense fixes.
Fixing the chart and walking away. The vital few shift over time. After you address the top causes, the next tier moves up. Rebuild the chart periodically, especially after interventions, to confirm the problem distribution has actually changed.