Pareto Chart in Excel — Step-by-Step + Free Template

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.

Download the ready-made Pareto template

The tutorial below builds the chart from scratch, which is worth doing once. If you just need the file today, this is the same structure already set up — counts in, percentages and cumulative line calculated for you. No signup, no email.

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.

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:

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:

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:

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:

In cell D3, enter:

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

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:

• Color the vital few bars — Click each bar individually (click once to select all bars, click again to select one bar). Color bars to the left of the 80% crossing point in a bold color (e.g., blue). Color remaining bars in gray. This instantly communicates where the team should focus.
• Add data labels to bars — Right-click bars → Add Data Labels → position: Outside End. This shows exact counts without needing to read the axis.
• Add data labels to the cumulative line — Same process. Position: Above. This shows cumulative percentage at each point.
• Add axis titles — Left axis: “Number of Tickets” (or whatever you are counting). Right axis: “Cumulative Percentage.”
• Add a chart title — Use a descriptive title: “Support Ticket Categories — Q1 2026 (n=434).” Including the sample size (n) adds credibility.
• Remove gridlines — For a cleaner look, remove or lighten the horizontal gridlines. The data labels make them redundant.

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.

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.

Frequently asked questions

Related resources

• Pareto Analysis: The Complete Guide with Examples — theory, 7 industry examples, and when to use (or not use) the 80/20 rule
• Pareto Chart Examples: 6 Real-World Cases Across Industries — full data tables from manufacturing, healthcare, software, and more
• Free Pareto Chart Template (Online & Excel) — ready-to-use templates
• 5 Whys vs. Pareto Analysis: When to Use Each — one drills deep, the other prioritizes wide
• Root Cause Analysis: A Complete Guide — the big picture on RCA methodology
• Free Pareto Chart Maker (online tool) — build your chart in 30 seconds, no Excel needed