Practical guide · Root cause analysis and problem solving
Pareto chart (Pareto diagram): what it is, how to build and read one, with a worked example by count and by cost
Short answer
A Pareto chart, also called a Pareto diagram or Pareto graph, is a bar chart with the bars sorted from largest to smallest and a line over them showing the cumulative percentage. It shows which few categories make up most of a total, so a team works on those first. The bars can count occurrences, minutes or cost.
A Pareto chart ranks the categories of one problem, such as defect types or downtime reasons, from the biggest to the smallest, with a cumulative percentage line over the bars. To build one, count each category, sort them, work out each share of the total and the running total, and draw the bars and the line. Read it from the left: the first few bars are the ones to work on. Build it by count and by cost, because the order often changes. Doing all of that and then choosing the first project is Pareto analysis; the 80/20 rule behind it is the Pareto principle.
Last reviewed:
What a Pareto chart is
A Pareto chart is a bar chart with its bars sorted in descending order and a line on top showing the running total as a percentage. The bars use the left axis (a count, minutes or money) and the line uses the right axis (0 to 100%). It rests on the 80/20 idea: when several things contribute to a result, a few of them usually account for most of it. The chart shows which few, with your own data. It is one of the seven basic quality tools, and it is the usual first step before a fishbone or 5 Whys, because it tells the team which problem deserves the investigation.
The 80/20 split is a rule of thumb, not a law. In one set of data the top two categories may make up 85% and in another it takes five categories to reach 60%. Whatever your data says is the answer; a flat chart is a finding too, because it says there is no single big lever.
Pareto chart, Pareto diagram, Pareto graph, Pareto analysis: the names
Pareto chart, Pareto diagram and Pareto graph are three names for the same picture. The line over the bars is sometimes called the Pareto curve or Pareto line. The Pareto principle is the 80/20 rule itself: the observation that a few causes usually account for most of an effect. It is named after Vilfredo Pareto, the Italian economist who noticed the same lopsided pattern in the distribution of wealth, and Joseph Juran brought it into quality management, calling the few big causes the vital few and the rest the trivial many. Pareto analysis is the method: collect the data, draw the chart, pick the vital few and hand them to a root cause method. This page covers all of it.
The parts of a Pareto chart
| Part | What it is | What to look at |
|---|---|---|
| Bars | One per category, tallest on the left, in descending order | The first two or three bars are the candidates for a project |
| Left axis | The measure: a count of events, minutes lost or money | Check the unit. A chart by count and a chart by cost can rank the same causes differently |
| Cumulative line (Pareto curve) | A point above each bar at the running total as a percentage, joined by a line, read on the right axis from 0 to 100% | Where it bends from steep to flat is where the vital few end |
| Right axis | 0 to 100% for the cumulative line | The last point is always 100%. If it is not, a category is missing or a share is wrong |
| 80% cut | An optional threshold line at 80% on the right axis | The bars to the left of where the curve crosses it are the vital few. Treat it as a guide, not a rule |
| Other bar | Rare or mixed categories lumped together, always the last bar whatever its size | If it is taller than the biggest named bar, the categories are too coarse |
When to use a Pareto chart, and when not to
Use a Pareto chart when one problem has several categories and you need to decide which to work on first: defect types on a line, downtime reasons on a machine, complaint types in a quarter, near miss types in a plant, or the components of a broad cause once the first chart has named it. It is also the clearest way to show a steering group why the team chose the project it chose.
- Do not use it for measured values of one characteristic, such as diameters or fill weights. That is a histogram, which groups the readings into ranges in their natural order instead of ranking categories.
- Do not use it to see change over time. A control chart or a run chart shows whether the process shifted and when; a Pareto chart has no time axis.
- Do not use it with fewer than about four categories or a handful of events. There is nothing to rank, and the order will change next week.
- Do not mix units. Every bar must be in the same measure for the same period, or the ranking means nothing.
How to make a Pareto chart in six steps
- 1
Choose one problem and one period
Scrap on one line, downtime on one machine, complaints in one quarter. Mixing problems gives a chart nobody can act on.
- 2
Choose the categories and the measure
Use reason codes the floor already uses, such as a defect check sheet or the downtime reason codes. The measure is a count, minutes or cost. Keep it to 6 to 10 categories plus an Other.
- 3
Collect the data
Tally for long enough that the order of the bars is stable. A few events are not enough to rank anything.
- 4
Sort and total
Sort the categories largest first, with Other always last, however big it is. Add them up for the grand total.
- 5
Work out the share and the cumulative share
Share = category value ÷ grand total × 100. Cumulative = this share plus all the shares above it. The last one must be 100%.
- 6
Draw it and mark the cut
Bars in sorted order on the left axis, the cumulative points joined on the right axis, and a line at 80% if you use that cut. The Pareto chart template does the sorting and drawing in Excel.
Pareto chart example: scrap on one line, by count and by cost (illustrative)
This example is made up. A machining cell scrapped 500 parts in a month across eight causes. The first table is the Pareto by count.
| Cause | Parts | Share | Cumulative |
|---|---|---|---|
| Burrs | 180 | 36.0% | 36.0% |
| Wrong dimension | 110 | 22.0% | 58.0% |
| Scratches | 75 | 15.0% | 73.0% |
| Porosity | 50 | 10.0% | 83.0% |
| Dents | 35 | 7.0% | 90.0% |
| Paint run | 25 | 5.0% | 95.0% |
| Wrong label | 15 | 3.0% | 98.0% |
| Other | 10 | 2.0% | 100.0% |
Check: 180 + 110 + 75 + 50 + 35 + 25 + 15 + 10 = 500. Four causes reach 83%, the first bar to pass 80%.
The 500 scrapped parts as a Pareto chart
Example numbers- Burrs: 180, 36% of the total, cumulative 36%.
- Wrong dimension: 110, 22% of the total, cumulative 58%.
- Scratches: 75, 15% of the total, cumulative 73%.
- Porosity: 50, 10% of the total, cumulative 83%.
- Dents: 35, 7% of the total, cumulative 90%.
- Paint run: 25, 5% of the total, cumulative 95%.
- Wrong label: 15, 3% of the total, cumulative 98%.
- Other: 10, 2% of the total, cumulative 100%.
Bars for burrs 180, wrong dimension 110, scratches 75, porosity 50, dents 35, paint run 25, wrong label 15 and other 10, with the cumulative line passing 80 percent at porosity, the fourth bar, at 83 percent.
By count, burrs are the biggest problem and the first project. Now put a cost on each scrapped part, which is what it cost the plant to make up to the point it was scrapped. The costs per part, again illustrative, are: burrs $2, wrong dimension $8, scratches $3, porosity $12, dents $5, paint run $4, wrong label $20 and other $5.
| Cause | Parts × cost per part | Cost | Share | Cumulative |
|---|---|---|---|---|
| Wrong dimension | 110 × $8 | $880 | 32.7% | 32.7% |
| Porosity | 50 × $12 | $600 | 22.3% | 55.0% |
| Burrs | 180 × $2 | $360 | 13.4% | 68.4% |
| Wrong label | 15 × $20 | $300 | 11.2% | 79.6% |
| Scratches | 75 × $3 | $225 | 8.4% | 87.9% |
| Dents | 35 × $5 | $175 | 6.5% | 94.4% |
| Paint run | 25 × $4 | $100 | 3.7% | 98.1% |
| Other | 10 × $5 | $50 | 1.9% | 100.0% |
Check: 880 + 600 + 360 + 300 + 225 + 175 + 100 + 50 = $2,690.
Pareto by cost: the same 500 parts, as a Pareto chart
Example numbers- Wrong dimension: 880, 33% of the total, cumulative 33%.
- Porosity: 600, 22% of the total, cumulative 55%.
- Burrs: 360, 13% of the total, cumulative 68%.
- Wrong label: 300, 11% of the total, cumulative 80%.
- Scratches: 225, 8% of the total, cumulative 88%.
- Dents: 175, 7% of the total, cumulative 94%.
- Paint run: 100, 4% of the total, cumulative 98%.
- Other: 50, 2% of the total, cumulative 100%.
Bars for wrong dimension $880, porosity $600, burrs $360, wrong label $300, scratches $225, dents $175, paint run $100 and other $50, with the cumulative line passing 80 percent at the fifth bar.
Burrs fall from first to third: they are 36% of the parts and 13.4% of the money. Wrong dimension and porosity, 32% of the parts between them, are 55% of the cost. Wrong label is only 3% of the parts and 11.2% of the cost. Which chart to act on depends on the goal: to cut scrap cost, start with wrong dimension; to cut the number of rejects the operators handle, burrs are still worth a quick fix. Showing both charts side by side is what makes the choice an informed one.
The second-level Pareto: where the top bar comes from
The team picks wrong dimension. Before drawing a fishbone, they split those 110 parts by the machine that made them. This is stratification: a Pareto inside the Pareto.
| Machine | Parts | Share | Cumulative |
|---|---|---|---|
| Lathe 1 | 70 | 63.6% | 63.6% |
| Lathe 2 | 25 | 22.7% | 86.4% |
| Lathe 3 | 15 | 13.6% | 100.0% |
Check: 70 + 25 + 15 = 110. Shares: 70 ÷ 110 = 63.6%, 25 ÷ 110 = 22.7%, 15 ÷ 110 = 13.6%. Cumulative after two machines: 95 ÷ 110 = 86.4%.
Two of three lathes make the same parts and one of them produces 64% of the dimensional scrap. The problem statement for the fishbone is now 'wrong dimension on lathe 1, 70 parts last month', which is a much better head than 'scrap'. Each level of Pareto narrows the question before anyone starts guessing at causes.
How to make a Pareto chart in Excel, or with the free maker
- 1
Excel 2016 and later: the built-in chart
Put the categories in one column and the values in the next, select both, then Insert, Insert Statistic Chart, Pareto. Excel sorts the bars and draws the cumulative line for you (Microsoft Support, 'Create a Pareto chart'). You cannot control where Other sits, so lump the small categories into an Other row before you start, or use the manual method.
- 2
Any spreadsheet: the manual method
Sort the rows by value, largest first, with Other moved to the bottom. Add a Share column (value ÷ total) and a Cumulative column (running sum of Share). Insert a combo chart: clustered columns for the values and a line for Cumulative on a secondary axis set from 0 to 100%. Add a horizontal line at 80% if you use the cut.
- 3
The template
The Pareto chart template has the tally sheet, the chart by count and by cost with the line and the 80% threshold cut, and a before and after comparison already built. Type the counts and it sorts and draws.
- 4
The free maker
The Pareto chart maker takes pasted categories and counts and gives you the sorted bars, the cumulative line and the vital few at the 80% line as a PNG or SVG for a board or a report. Nothing to install and no sign-up.
How to read a Pareto chart
- Start at the left. The first bars are the ones to work on, and the cumulative line tells you how much of the total they cover.
- Look at where the line bends. A steep start and a flat tail means a few causes dominate. A line close to straight means the causes are about equal and a different cut of the data is needed.
- Check Other. If it is bigger than the largest named bar, the categories are too coarse. Split it and count again.
- Do not stop at one chart. Break the top bar down by machine, shift or product (a second Pareto inside the first) to find where it is made, as the reduce scrap and rework guide does for one month of reason codes.
- Re-draw it after the fix with the same categories and the same period length. If the top bar did not come down, the fix did not work.
Mistakes that mislead
| Mistake | What goes wrong | Do this instead |
|---|---|---|
| Only counting frequency | The cheap, frequent problem wins over the rare, costly one | Build it by cost or minutes as well |
| Not sorting, or putting Other in the middle | The chart no longer shows the vital few | Descending order, Other last |
| A big Other bar | The largest problem may be hiding in it | Split categories until Other is small |
| Too few events | The order of the bars changes next week | Count for long enough that the top bars hold |
| Treating 80% as exact | Work stops at a line that means nothing | Use it as a guide to where the bars level off |
| Stopping at the chart | The chart picks a problem but nothing is fixed | Hand the top bar to a root cause method and an owner |
| Ranking causes nobody can act on | 'Operator error' or 'unknown' tops the chart | Use reason codes that name a condition, and split 'unknown' until it is small |
Pareto chart vs bar chart, histogram and Pareto analysis
| Tool | What it shows | How it differs from a Pareto chart |
|---|---|---|
| Bar chart | Any categories in any order, often alphabetical or by process step | A Pareto chart is a bar chart with two rules added: descending order and a cumulative line. Only the order makes the vital few visible |
| Histogram | How measured values of one characteristic are spread across ranges | A histogram keeps the ranges in their natural order and has no cumulative line. Excel lists both under Statistic Charts, which is why people ask whether a Pareto chart is a histogram. It is not |
| Pareto principle (80/20 rule) | The idea that a few causes account for most of an effect | The principle is the expectation; the chart is the test of it with your own data |
| Pareto analysis | The whole method: define the problem, collect data, draw the chart, choose the vital few, verify, assign | The chart is one step of the analysis |
| Stratification | The same data cut by machine, shift, product or supplier | A second-level Pareto is stratification applied to the top bar |
What to do after the chart
The Pareto names the problem. It does not explain it. Take the top bar to a fishbone if it could come from several areas, or to the 5 Whys if it looks like one chain, and use the problem solving methods guide to choose between them. For downtime, the reduce machine downtime guide works a month of stops through the same sort-and-cut.
To keep a Pareto alive instead of redrawing it by hand each month, LeanSuite's loss and cost management page describes putting a cost on each loss so the biggest can be fixed first, and its micro-stops page covers logging short stops so they show up in the ranking.
Make one now
Paste your counts into the free Pareto chart maker for a chart you can drop into a report, or download the Pareto chart template for the tally sheet and the charts by count and by cost in Excel. Collect the counts on a defect check sheet or with the downtime reason codes, and take the top bar to the root cause analysis template.
Definitions and notes
- The Pareto chart is one of the seven basic quality tools: bars in descending order with a cumulative percentage line (ASQ, "Pareto chart"). It applies the 80/20 idea attributed to Vilfredo Pareto and brought into quality management by Joseph Juran, who named the vital few and the trivial many (Juran, Quality Control Handbook).
- Excel's built-in Pareto chart type, under Insert Statistic Chart, is described in Microsoft Support, "Create a Pareto chart". Versions before Excel 2016 need the manual combo-chart method.
- The scrap counts, costs per part, the split by machine and the totals are made up for illustration. They are not from a real plant. Every share is the cause's value divided by its table's total, rounded to one decimal.
- Cost per scrapped part here is the cost put into the part up to the step where it was scrapped. How you set it is a decision for your own finance team.
Go deeper
This page is the short version. These guides cover each part in full.
- Pareto Analysis in Manufacturing: Applying the 80/20 Rule to Problem SolvingThe full blog guide to Pareto analysis in a plant, beyond the arithmetic here.
- The Six Big Losses in Lean ManufacturingA ready-made set of loss categories for a downtime or OEE Pareto.
- How to Reduce Manufacturing DowntimeWhat to do once a downtime Pareto has named the top reason.
All our articles on this subject are in the root cause analysis and problem solving topic.
Free templates and tools
- Pareto chart templateA tally sheet, the Pareto by count and by cost with the cumulative line and the 80 percent threshold, and a before and after comparison. Excel sorts and draws it.
- Defect check sheetTally defects by type and day, with units inspected, defect rates, a location sheet and the week's Pareto.
- Downtime reason codes template26 starter codes mapped to the six big losses, a log with drop-downs, a Pareto by code and by loss, and a code card for the line.
- Six big losses worksheetWhere a machine's planned time goes: the six big losses in minutes, ranked, with A, P, Q and OEE worked out.
- Root cause analysis templateOne report from problem statement to proof: containment, evidence, analysis, verified causes, actions and the effectiveness check.
- 5 Whys templateA problem statement, a why chain that can branch, evidence for every answer, root causes and countermeasures that are checked.
- Pareto chart makerPaste categories and counts: sorted bars, cumulative percentage line and the vital few at the 80% line, as a PNG or SVG.
- Histogram makerPaste measurements: the histogram with automatic or chosen bins, plus mean, median and standard deviation, as a PNG or SVG.
- Scrap rate calculatorScrap rate, the cost of scrap per period and per year, and what reaching a target rate would save.
- Downtime cost calculatorWhat an hour, an event and a year of unplanned downtime cost, from lost output, idle labour, scrap and overtime.
- Cost of poor quality (COPQ) calculatorTotal COPQ and cost of quality, and each as a share of revenue, from the four quality cost categories.
Doing this in LeanSuite
Loss & Cost Management
Shows where your plant loses money, puts a cost on each loss and gives you the tools to remove it.
See Loss & Cost ManagementMicro-stops
Log the brief jams your ERP and MES never report, and see which micro-stops cost the most so you can win back OEE.
See Micro-stopsKPI Dashboards
Turns raw shop floor data into dashboards anyone can read, so everyone from operators to the plant manager can act on performance.
See KPI Dashboards
See it on your own lines
Bring the problem you are working on to a 45-minute demo. Or look around with sample data first, or pilot LeanSuite on your own lines for 90 days, with the setup done by our team.
FAQ
Questions about pareto chart
It is used to decide what to work on first. It ranks the categories of one problem, such as defect types or downtime reasons, from largest to smallest, with a cumulative line, so the few categories that make up most of the total stand out. It is usually drawn before a root cause investigation.
Read from the left. The tallest bars are the biggest contributors, and the cumulative line shows how much of the total they cover together. Look for where the line starts to flatten: the bars before that point are the ones to work on. A near-straight line means no single cause dominates.
It is the idea that a few causes, often about 20% of them, account for most of a result, often about 80%. Joseph Juran named it the Pareto principle, after the economist Vilfredo Pareto. It is a rule of thumb, not a law. Your own data may show 90% from two causes or 60% from five, and the chart shows which it is.
Build both when you can. A count shows what happens most often and a cost shows what hurts most, and the order often differs. In the worked example on this page, burrs are first by count at 36% of parts but third by cost at 13.4% of the money, so the choice of measure changes the first project.
A Pareto chart ranks separate categories, such as defect types, in descending order. A histogram groups measured values of one characteristic, such as a diameter, into ranges in their natural order to show how the values are spread. Use a Pareto to choose a problem and a histogram to understand variation.
No. Excel lists both under Statistic Charts, which causes the confusion, but they answer different questions. A histogram shows the spread of one measured value across ranges kept in their natural order. A Pareto chart ranks categories in descending order and adds a cumulative percentage line. The bars in a Pareto chart are categories, not ranges of a measurement.
There is none. Pareto chart, Pareto diagram and Pareto graph are three names for the same chart: bars sorted from largest to smallest with a cumulative percentage line. The line is sometimes called the Pareto curve. Pareto analysis is the method of collecting the data, drawing the chart and choosing the vital few to work on.
Pareto analysis is the method around the chart. Define one problem and one period, choose the categories and the measure, collect the counts, draw the chart, pick the few categories that make up most of the total, check the ranking by cost or minutes as well as by count, then hand the top category to a root cause method with an owner. The chart is one step in it.
In Excel 2016 and later, put the categories in one column and the values in the next, select both and choose Insert, Insert Statistic Chart, Pareto. Excel sorts the bars and adds the cumulative line. In older versions or Google Sheets, sort the rows largest first, add a share column and a running cumulative column, and insert a combo chart with columns for the values and a line for the cumulative percentage on a secondary axis from 0 to 100%.
The line, sometimes called the Pareto curve, shows the running total as a percentage, read on the right axis. The point above the first bar is that bar's share of the total, the point above the second is the first two shares added together, and so on until the last point reaches 100%. Where the line stops rising steeply is where the vital few end.
Six to ten named categories plus an Other bar is a good range. Fewer than about four and there is nothing to rank. More than ten and the chart gets hard to read, so lump the small ones into Other, which always sits last. If Other grows taller than the biggest named bar, the categories are too coarse and need splitting.
Related guides and tools
- Free Pareto chart maker: paste your counts and get the cumulative line
- Free Pareto chart template in Excel: tally sheet, chart by count and by cost, 80% cut
- Free defect check sheet for collecting the counts a Pareto chart needs
- Fishbone diagram: where the top bar of the Pareto goes next
- Histogram: see how a measurement is spread, where a Pareto ranks categories
- How to reduce scrap and rework, starting from a Pareto of defects
More method guides
- The 6 Ms of production
- Poka-yoke
- Model area 90-day plans
- Moving from Excel to one system
- Reducing machine downtime: a worked month
- Andon
- Cycle time vs lead time, worked through
- Root cause analysis
- How many operators a line needs
- Reducing scrap and rework: a worked month
- Unsafe acts and unsafe conditions
- Just culture
- Stop-work authority
- Material review board (MRB)
- Nonconformance and NCRs
- Problem solving methods
- Quad chart
- OEE calculation
- Quality assurance vs quality control
- SOP meaning and format
- Job hazard analysis
- Near miss reporting
- Fishbone diagram
- Histogram
- Control chart
- What is a gemba walk
- What is lead time
- What is operational excellence
- How to improve product quality
- Preventive vs predictive maintenance
- Kanban
- FMEA
- PDSA cycle
- Safety moments
- Just-in-time manufacturing
- Kaizen
- 5S
- Total quality management (TQM)
- CAPA (corrective and preventive action)
- Layered process audit (LPA)
- Lean tools
- Lockout tagout (LOTO)
- A3 problem solving
- Preventive maintenance
- APQP
- High reliability organization (HRO)
- Manufacturing KPIs
- Quality metrics
- Practical problem solving
- CMMS
- Risk assessment
- Production efficiency
- Total productive maintenance (TPM)
- Reliability-centered maintenance (RCM)
- Hierarchy of controls
- Personal protective equipment (PPE)
- Emergency action plan
- Safety signs
- Warehouse safety
- ISO 9001
- SIPOC diagram
- Rolling action item list (RAIL)
- Pugh matrix
- Flowchart
- Project charter
- ISO 9001:2026
- Fleet maintenance
- IATF 16949
- AS9100
- ISO 14001
- ISO 45001
- One point lesson
- Standard work
- Lean manufacturing principles
- Toyota Production System
- 5W1H
- 5 Whys
- Continuous improvement
- Takt time
- DMAIC
- PDCA
- 8D problem solving
- Prioritization matrix
- Gemba walk questions
- 5W1H questions
- Layered process audit questions
- 5S audit questions
Or browse the topics, the full library and the lean glossary.
Rather see it on your own problem?
Bring the problem you are stuck on, and we will show you on a call how LeanSuite handles it.

