How to make a Pareto chart in Excel (and a faster alternative)
The most-searched Pareto question on the internet is how to build the chart in Excel. Here is the complete recipe — and an honest look at where a dedicated tool saves you the formula wrangling.
· 7 min read
Example data: weekly website error counts by type
| Error type | Occurrences |
|---|---|
| Timeout | 310 |
| 404 page | 190 |
| Payment failed | 120 |
| Form validation | 60 |
| Upload failed | 35 |
| Other | 15 |
Illustrative numbers. The interactive chart below runs the same data — paste your own export to replace it.
The Excel recipe, step by step
Put your categories in one column and their counts in the next. Then follow these steps — they work in Excel 2016 and later, including Microsoft 365.
- Sort the data by count, largest to smallest (Data → Sort).
- Add a third column: the running total of counts (SUM expanding range).
- Add a fourth column: running total divided by the grand total, formatted as a percentage.
- Select categories, counts and the cumulative percentage column.
- Insert → Combo chart: bars for counts on the primary axis, line for cumulative % on the secondary axis.
- Add a horizontal line at 80% — an extra series or a shape — to mark the threshold.
The common mistakes
Unsorted bars are the classic error: without sorting, the cumulative line is meaningless. The second is a cumulative line computed on unsorted data — same problem, harder to spot.
The third is forgetting the secondary axis, which squashes the percentage line flat against the bottom of the chart.
The faster alternative
The interactive chart below this article does all six steps at once: paste two columns, get sorted bars, a cumulative line and an 80% threshold instantly. It also tells you which categories cross the threshold — the part Excel never computes for you.
Use Excel when the chart must live inside a spreadsheet deliverable. Use the tool when you want the answer, not the plumbing.
Run this analysis yourself
The example data is already loaded. Edit it, or paste your own, and the vital few update instantly.
Calculations run in your browser. Saving uploads the analysis; asking AI sends its data for processing.
CSV, TSV or pasted spreadsheet cells. Delimiter detected automatically (6 data rows).
Saving supports up to 500 input rows. Duplicate labels are combined in the result.
Preview the first 20 usable rows
Example data: weekly website error counts by type
- Total
- 730
- Categories
- 6
- Vital few
- 3
- Top 20% share
- 68.5%
Priority #1
Timeout
42.47% of total · 310
| # | Category | Value | Share | Cumulative |
|---|---|---|---|---|
| 1 | Timeout Vital few | 310 | 42.47% | 42.47% |
| 2 | 404 page Vital few | 190 | 26.03% | 68.49% |
| 3 | Payment failed Vital few | 120 | 16.44% | 84.93% |
| 4 | Form validation | 60 | 8.22% | 93.15% |
| 5 | Upload failed | 35 | 4.79% | 97.95% |
| 6 | Other | 15 | 2.05% | 100% |
3 of 6 categories account for 84.9% of total impact.
Vital few: Timeout, 404 page, Payment failed.
Timeout is the largest contributor at 42.47%.
Timeout represents 310 of a total of 730.
Moderate concentration: the top 20% of categories hold 68.5%.
There is a leading group, but the long tail still matters.
3 categories share the remaining 15.1%.
These are the trivial many under the Pareto principle.
Review Timeout first.
It is the single largest contributor at 42.47% of total impact.
Review opportunities across the wider process.
Impact is spread out — the top 20% only accounts for 68.5%.
Want to keep this analysis?
Create a free account to save this analysis. Shareable reports are included in Pro.
Key takeaways
- Sort first — every other step depends on it.
- Bars on the primary axis, cumulative % on the secondary.
- The threshold crossing, not the chart itself, is the deliverable.