Skip to content
LeanSuite

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

What each part of the chart is and what it tells you
PartWhat it isWhat to look at
BarsOne per category, tallest on the left, in descending orderThe first two or three bars are the candidates for a project
Left axisThe measure: a count of events, minutes lost or moneyCheck 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 axis0 to 100% for the cumulative lineThe last point is always 100%. If it is not, a category is missing or a share is wrong
80% cutAn optional threshold line at 80% on the right axisThe bars to the left of where the curve crosses it are the vital few. Treat it as a guide, not a rule
Other barRare or mixed categories lumped together, always the last bar whatever its sizeIf 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. 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. 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. 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. 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. 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. 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.

Pareto by count: 500 scrapped parts (illustrative)
CausePartsShareCumulative
Burrs18036.0%36.0%
Wrong dimension11022.0%58.0%
Scratches7515.0%73.0%
Porosity5010.0%83.0%
Dents357.0%90.0%
Paint run255.0%95.0%
Wrong label153.0%98.0%
Other102.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.

The same numbers as the table. Four causes reach 83%, the first bar to pass the dashed 80% line; by count, burrs are the first project.

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.

Pareto by cost: the same 500 parts (illustrative)
CauseParts × cost per partCostShareCumulative
Wrong dimension110 × $8$88032.7%32.7%
Porosity50 × $12$60022.3%55.0%
Burrs180 × $2$36013.4%68.4%
Wrong label15 × $20$30011.2%79.6%
Scratches75 × $3$2258.4%87.9%
Dents35 × $5$1756.5%94.4%
Paint run25 × $4$1003.7%98.1%
Other10 × $5$501.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.

The same 500 parts ranked by cost instead of count. Burrs fall from first to third, and wrong dimension and porosity become the first projects.

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.

Second-level Pareto: the 110 wrong-dimension parts by machine (illustrative)
MachinePartsShareCumulative
Lathe 17063.6%63.6%
Lathe 22522.7%86.4%
Lathe 31513.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. 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. 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. 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. 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

Common mistakes and what to do instead
MistakeWhat goes wrongDo this instead
Only counting frequencyThe cheap, frequent problem wins over the rare, costly oneBuild it by cost or minutes as well
Not sorting, or putting Other in the middleThe chart no longer shows the vital fewDescending order, Other last
A big Other barThe largest problem may be hiding in itSplit categories until Other is small
Too few eventsThe order of the bars changes next weekCount for long enough that the top bars hold
Treating 80% as exactWork stops at a line that means nothingUse it as a guide to where the bars level off
Stopping at the chartThe chart picks a problem but nothing is fixedHand the top bar to a root cause method and an owner
Ranking causes nobody can act on'Operator error' or 'unknown' tops the chartUse reason codes that name a condition, and split 'unknown' until it is small

Pareto chart vs bar chart, histogram and Pareto analysis

Close relatives and how they differ
ToolWhat it showsHow it differs from a Pareto chart
Bar chartAny categories in any order, often alphabetical or by process stepA Pareto chart is a bar chart with two rules added: descending order and a cumulative line. Only the order makes the vital few visible
HistogramHow measured values of one characteristic are spread across rangesA 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 effectThe principle is the expectation; the chart is the test of it with your own data
Pareto analysisThe whole method: define the problem, collect data, draw the chart, choose the vital few, verify, assignThe chart is one step of the analysis
StratificationThe same data cut by machine, shift, product or supplierA 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.

Free templates and tools

FAQ

Questions about pareto chart

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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%.

  10. 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.

  11. 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.

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.

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.