This free Pareto chart calculator sorts your problem categories, calculates cumulative percentages and shows you the “vital few” causes that create most of your losses. The Pareto principle – the 80/20 rule – says that roughly 80% of effects come from 20% of causes. Below you will find the calculator, a step-by-step guide to Pareto analysis, a worked example from a production line and the most common mistakes.
Free Pareto Chart Calculator
Type each cause (for example a defect type or stop reason) and its value (count, minutes or cost), or paste two columns straight from Excel. Add a cost per unit to rank by money instead of frequency. The chart, the A/B/C classes and the cumulative table update as you type, and you can download the analysis as an Excel file with live formulas.
Pareto Chart Calculator (80/20)
Pro · freeKey takeaways
- A Pareto chart is a bar chart sorted from largest to smallest with a cumulative percentage line.
- 80/20 is a rule of thumb, not a law – your split may be 70/30 or 90/10.
- Rank by cost or downtime minutes, not only by frequency.
- Pareto tells you where to look, root cause analysis tells you why.
What Is the Pareto Principle (80/20 Rule)?
The principle is named after the Italian economist Vilfredo Pareto, who observed that a small share of the population owned most of the land in Italy. Quality pioneer Joseph Juran applied the idea to quality problems and coined the phrase “the vital few and the trivial many”.
In manufacturing the pattern shows up everywhere: a handful of defect types create most of the scrap, a few stop reasons cause most of the downtime and a small group of suppliers causes most late deliveries. A Pareto chart makes that pattern visible in seconds.
How to Do a Pareto Analysis in 5 Steps
1. Define the problem and the measure
Decide what you are measuring: number of defects, downtime minutes or cost in €. The choice of measure can completely change the ranking.
2. Choose clear categories
Use 5–10 categories that don’t overlap. Avoid a huge “Other” category – if it ends up in the top three, your categories are too vague.
3. Collect data for a representative period
Two to four weeks is usually enough for daily production problems. Use a simple check sheet at the workstation or export the data from your MES.
4. Build the Pareto chart
Enter the data into the Pareto chart calculator above. It sorts the categories from largest to smallest and adds the cumulative percentage for each.
5. Act on the vital few
Select the categories that together reach about 80% and launch improvement actions on them first. After the actions, collect data again and draw a new chart to prove the effect.
Worked Example: Downtime on a Window Assembly Line
| Stop reason | Minutes / month | Share | Cumulative % |
|---|---|---|---|
| Missing hardware parts | 420 | 42% | 42% |
| Welding machine changeover | 260 | 26% | 68% |
| Glass delivery delay | 130 | 13% | 81% |
| Cleaning machine fault | 80 | 8% | 89% |
| Quality hold | 60 | 6% | 95% |
| Other | 50 | 5% | 100% |
| Total | 1,000 | 100% |
Three of six causes create 81% of the downtime. The team focuses on a kanban for hardware parts and on SMED for the welding changeover. Fixing the cleaning machine first would feel productive, but it would remove only 8% of the losses.
How to Read the Pareto Chart Calculator Results
After you click “Generate Analysis”, the Pareto chart calculator returns a sorted table with each cause, its value and the cumulative percentage. Read it from the top:
- Find the 80% line. The causes above roughly 80% cumulative are your vital few.
- Check the steepness. If the first cause alone is above 40–50%, you have one dominant problem – a focused project will pay off quickly.
- Look at “Other”. If it is large, split it into more specific categories and run the Pareto chart calculator again.
- Compare before and after. Save the results and repeat the Pareto analysis after your improvement actions to prove the effect.
Tip: run the Pareto chart calculator twice – once by frequency and once by cost or minutes. If the rankings differ, prioritise by cost, but don’t ignore frequent small problems that annoy operators every day.
Where to Use a Pareto Chart in Manufacturing
| Area | What to rank | Related tool |
|---|---|---|
| Quality | Defect types, customer complaints | Root cause analysis, 5 Whys |
| Maintenance | Stop reasons, failure modes | OEE calculator |
| Flow | Waiting causes at the constraint | Bottleneck analysis |
| Supply chain | Late deliveries by supplier | Supplier scorecard |
| Inventory | Value of stock by item (ABC analysis) | Kanban, supermarket |
Common Pareto Analysis Mistakes
- Counting instead of weighting. Ten cosmetic scratches may cost less than one cracked frame. Rank by cost or time when you can.
- Too short a period. One bad day can dominate a week of data.
- Mixing different problems. Don’t put defects and downtime on one chart.
- Stopping at the chart. The Pareto chart only shows where to dig. Use 5 Whys or a fishbone diagram for the cause.
- Treating 80/20 as exact. The point is the imbalance, not the exact numbers.
Pareto Chart FAQ
Is a Pareto chart one of the 7 basic quality tools?
Yes. Together with the check sheet, histogram, cause-and-effect diagram, control chart, scatter diagram and flowchart (or stratification), it belongs to the seven basic quality tools.
Can I make a Pareto chart in Excel?
Yes, newer Excel versions have a built-in Pareto chart type. For a quick analysis without formatting, the Pareto chart calculator on this page is faster.
What if my data doesn’t follow 80/20?
A flat chart means no single cause dominates. Check your categories – they may be too broad or too narrow – or look for a systemic cause such as missing standard work.
Next Steps
Pick one problem, collect two weeks of data and run it through the Pareto chart calculator. Then attack the top category and repeat. For a deeper background on the tool, see ASQ’s guide What is a Pareto Chart?
Related: See a complete worked downtime Pareto, from raw data to business recommendations, in remote process data analysis: 5 steps to find hidden losses.