Excel is still the most common tool for building Pareto charts in quality meetings, Six Sigma projects, and management reports. This tutorial walks you through building a professional Pareto chart from scratch — with cumulative percentage formulas, a dual-axis combo chart, an 80% threshold line, and vital-few color coding. No macros, no add-ins, just standard Excel features that work in Excel 2016, 2019, 2021, and Microsoft 365.

If you want a Pareto chart in 30 seconds without any spreadsheet work, try our free online Pareto Chart Maker — it calculates everything and exports a PNG instantly.

What you need before you start

A Pareto chart requires two columns of data:

  1. Category names — the distinct types of defects, errors, complaints, or issues you are tracking (e.g., “Solder bridging,” “Missing component”).
  2. Counts (frequency) — how many times each category occurred during your measurement period.

You need at least 4–5 categories and ideally 20+ total data points for the Pareto pattern to be meaningful. If you have raw event logs rather than pre-counted categories, use Excel’s COUNTIF function first to tally each category.

Tip: If some categories have equal impact per occurrence, use frequency as your count. If categories vary in severity or cost, consider using total cost or total impact score instead. The chart technique is the same — only the Y-axis label changes.

Step 1: Enter and sort your data

Open a new Excel workbook. In cells A1:B1, type your headers: Category and Count. Enter your data starting in row 2.

For this tutorial, we will use a real-world example — customer support ticket categories for a SaaS platform over one quarter:

 A (Category)B (Count)
1CategoryCount
2Login failures128
3Slow page load94
4Data sync errors71
5Notification bugs60
6UI rendering issues58
7Other23

Important: Sort rows 2–7 by column B from largest to smallest. The “Other” category always goes last, regardless of its count. In Excel: select A2:B7 → Data → Sort → Column B → Largest to Smallest. Then manually move the “Other” row to the bottom if sorting moved it.

Step 2: Calculate percentage of total

In cell C1, type the header % of Total. In cell C2, enter this formula:

=B2/SUM(B$2:B$7)

The dollar signs on B$2:B$7 lock the range so you can copy the formula down. Copy C2 to C3:C7.

Format column C as Percentage (Home → Number → Percentage, 1 decimal place). Your spreadsheet should now look like this:

CategoryCount% of Total
Login failures12829.5%
Slow page load9421.7%
Data sync errors7116.4%
Notification bugs6013.8%
UI rendering issues5813.4%
Other235.3%

Sanity check: The sum of column C should equal 100% (or very close due to rounding). If it does not, your SUM range is wrong.

Step 3: Calculate cumulative percentage

In cell D1, type Cumulative %. The cumulative percentage is a running total that shows what fraction of total issues is accounted for as you move down the ranked list.

In cell D2 (first row), enter:

=C2

In cell D3, enter:

=D2+C3

Copy D3 down to D7. Format column D as Percentage. The result:

CategoryCount% of TotalCumulative %
Login failures12829.5%29.5%
Slow page load9421.7%51.2%
Data sync errors7116.4%67.5%
Notification bugs6013.8%81.3%
UI rendering issues5813.4%94.7%
Other235.3%100.0%

The cumulative line crosses 80% after the fourth category (Notification bugs at 81.3%). This means the first three categories — Login failures, Slow page load, and Data sync errors — are just below the 80% mark at 67.5%. Depending on your team’s capacity, you might focus on 3 or 4 categories as the vital few.

Step 4: Create the combo chart

Now turn this data into a visual Pareto chart. Here’s how:

  1. 1
    Select columns A, B, and D

    Hold Ctrl (or Cmd on Mac) and select A1:A7, then B1:B7, then D1:D7. You need the category names, the raw counts, and the cumulative percentage — skip column C (% of Total).

  2. 2
    Insert a Combo Chart

    Go to Insert → Chart → Combo (or “Insert Combo Chart” in the Charts group). Choose: Clustered Column for “Count” and Line for “Cumulative %”. Check the “Secondary Axis” box for the Cumulative % series. Click OK.

  3. 3
    Adjust the secondary axis

    Double-click the right Y-axis (the percentage axis). Set: Minimum = 0, Maximum = 1.0 (which displays as 100%). This ensures the cumulative line starts at 0% and ends at 100%.

  4. 4
    Adjust the primary axis

    Double-click the left Y-axis (the count axis). Set Minimum = 0. The maximum will auto-scale, but you can set it manually for a cleaner look (e.g., 150 if your highest count is 128).

You should now have a basic Pareto chart: descending bars for counts and a rising line for cumulative percentage.

Step 5: Add the 80% threshold line

The 80% line is what turns a regular bar chart into a Pareto chart — it visually marks the cut-off between the vital few and the useful many.

  1. 1
    Create a helper column

    In cell E1, type 80% Line. In E2, enter 0.8. Copy E2 down to E7 (every cell has 0.8). Format as Percentage.

  2. 2
    Add the series to the chart

    Right-click the chart → Select Data → Add. Series name: click E1. Series values: select E2:E7. Click OK.

  3. 3
    Move it to the secondary axis

    Right-click the new series in the chart → Change Series Chart Type. Set it to Line on the Secondary Axis.

  4. 4
    Format as a dashed line

    Right-click the 80% line → Format Data Series → Line: choose a dashed style, orange or red color, 1.5pt weight. Remove markers. This gives you a clean horizontal reference line at 80%.

Step 6: Format and highlight the vital few

A good Pareto chart tells its story at a glance. Apply these finishing touches:

Pro tip: To highlight the vital few without clicking individual bars, use a helper column approach. Add a column F with the formula =IF(D2<0.8,B2,0) for “Vital” counts and column G with =IF(D2>=0.8,B2,0) for “Other” counts. Plot both as Stacked Column on the primary axis — one in blue, one in gray. This automates the coloring.

Excel’s built-in Pareto chart — pros and cons

Excel 365 and Excel 2016+ include a dedicated Pareto chart type: Insert → Charts → Histogram → Pareto. It’s quick, but limited.

FeatureBuilt-in ParetoManual combo chart
Setup time~30 seconds~10–15 minutes
80% threshold lineNot includedFull control (dashed, colored)
Vital-few color codingNot availableFull control per bar
Data labelsLimited placementFull control
Cumulative % on secondary axisAutomaticManual setup
“Other” category handlingNo special treatmentYou control placement
Best forQuick internal reviewReports, presentations, audits

Recommendation: Use the built-in Pareto for a quick sanity check during analysis. Use the manual combo chart for any chart that will be shared with stakeholders, included in a report, or presented in a meeting. The 80% line and color coding are essential for clear communication.

If you need a Pareto chart faster than either Excel method — our online Pareto Chart Maker generates a complete chart with vital-few highlighting, cumulative line, and PNG export in under 30 seconds.

Pareto chart in Google Sheets

Google Sheets does not have a built-in Pareto chart type, but the manual combo chart technique works almost identically:

  1. Enter and sort data in columns A–B (same as Step 1).
  2. Add % of Total in column C and Cumulative % in column D (same formulas).
  3. Select A:A, B:B, and D:D → Insert → Chart.
  4. In the Chart Editor, change chart type to Combo chart.
  5. Under “Customize → Series,” set Count to Column and Cumulative % to Line. Check “Right axis” for the Cumulative % series.
  6. For the 80% line: add a helper column with 0.8 in every row, add it as a third line series on the right axis, and style it as dashed.

The biggest difference: Google Sheets does not let you color individual bars differently, so the vital-few highlight requires a stacked column workaround (helper columns for “vital” vs. “other” counts, as described in the pro tip above).

5 common mistakes to avoid

  1. Forgetting to sort by descending count.

    The entire point of a Pareto chart is the left-to-right ranking. If bars are not sorted, the cumulative line has no meaning and the chart fails to communicate priorities. Always sort before charting.

  2. Placing “Other” by its count instead of last.

    If “Other” has a high count, sorting puts it near the left — making it look like a vital category. But “Other” is a catch-all that cannot be actioned. Always force it to the last position.

  3. Skipping the 80% threshold line.

    Without the line, viewers must mentally estimate where 80% falls. The whole purpose of Pareto is to separate vital few from useful many — the line makes this separation explicit and unambiguous.

  4. Not setting the secondary axis to 0–100%.

    If Excel auto-scales the secondary axis (e.g., 20%–100%), the cumulative line appears flattened and the 80% crossing point shifts visually. Always lock the axis to 0%–100%.

  5. Using too many categories.

    More than 10 bars makes the chart hard to read and dilutes the message. Consolidate low-frequency categories into “Other.” The goal is clarity, not completeness — if you need all categories for reference, put them in a data table below the chart.

Skip the spreadsheet — build your Pareto chart online

Enter categories and counts. Get cumulative percentages, 80% threshold, vital-few highlighting, and PNG export — all calculated automatically. Free, no signup.

Open Pareto Chart Maker →

Frequently asked questions

Does Excel have a built-in Pareto chart?

Yes. Excel 365 and Excel 2016+ include a Pareto chart type under Insert → Chart → Histogram → Pareto. However, it offers limited customization — you cannot control the 80% threshold line, vital-few coloring, or data label placement. For professional quality reports, building a combo chart manually gives you full control.

How do I calculate cumulative percentage in Excel?

First sort your data by count descending. In the first cumulative cell, enter =B2/SUM(B$2:B$7) where B is your count column. In the next row, enter =D2+C3 (previous cumulative + current percentage). Copy this formula down. The last row should reach 100%. Format the column as Percentage.

What is the 80/20 rule in a Pareto chart?

The 80/20 rule (Pareto Principle) states that roughly 80% of effects come from 20% of causes. In a Pareto chart, you draw a horizontal line at 80% on the cumulative percentage axis. Categories to the left of where the cumulative line crosses 80% are your “vital few” — the small number of causes responsible for most of the problem.

Can I make a Pareto chart in Google Sheets?

Google Sheets does not have a built-in Pareto chart type, but you can build one using the same combo chart technique described in this tutorial. Create a bar chart for counts, add a line series for cumulative percentage, and assign it to a secondary axis. The formulas are identical to Excel.

How many categories should a Pareto chart have?

Aim for 5 to 10 categories. Fewer than 4 may not reveal a meaningful pattern. More than 10 usually means you should consolidate low-frequency categories into an “Other” group. Always place “Other” last regardless of its count.

What is the difference between a Pareto chart and a histogram?

A histogram groups continuous numerical data into bins (ranges) and shows frequency distribution. A Pareto chart uses discrete categories sorted by frequency from highest to lowest, with an added cumulative percentage line. The Pareto chart is specifically designed for prioritization — identifying the vital few categories that account for most of the total.

Should I use count or cost as the Y-axis in a Pareto chart?

It depends on your goal. Use count (frequency) when all categories have roughly equal impact per occurrence — this is the most common approach. Use cost or monetary impact when categories vary significantly in severity — a rare but expensive defect might deserve higher priority than a frequent but cheap one. Some teams create both charts and compare the prioritization.

Related resources