I learned about Pareto charts during a quality control project where we were trying to figure out which types of defects were causing the most customer complaints. Someone mentioned the “80/20 rule” — that roughly 80% of problems usually come from 20% of causes — and a Pareto chart is the exact tool built to prove or disprove that on your own data. Once I built my first one, it became a staple in nearly every root-cause analysis I’ve done since.
What Is a Pareto Chart?
A Pareto chart is a combination chart that shows individual values as descending bars alongside a cumulative percentage line. The bars are sorted from largest to smallest, so you can immediately see which categories contribute the most to a total. The cumulative line, plotted on a secondary axis, shows the running total percentage as you move from the biggest contributor to the smallest — making it easy to spot the “vital few” causes responsible for the majority of the effect.
Excel actually includes Pareto as a built-in chart type, which makes this far easier than manually building the sorted bars and cumulative line yourself.
When Should You Use a Pareto Chart?
I use Pareto charts when:
- I’m doing root-cause analysis on defects, complaints, or errors
- I want to identify which few factors account for the majority of a problem or outcome
- I’m prioritizing where to focus limited resources for maximum impact
- I need to visually communicate the 80/20 principle to a team or stakeholder
If your categories are already fairly even in value, a Pareto chart won’t reveal much — its power comes from highlighting imbalance.
Required Data Structure
You need two columns: a category name and its corresponding count or value. You don’t need to pre-sort or pre-calculate cumulative percentages — Excel’s built-in Pareto chart type handles that automatically. Here’s an example:
| Defect Type | Count |
|---|---|
| Scratched Surface | 145 |
| Wrong Color | 38 |
| Missing Parts | 22 |
| Packaging Damage | 15 |
| Late Delivery | 8 |
| Other | 5 |
Step-by-Step Instructions
Here’s exactly how I build one:
- Enter your data with category names in one column and their values in the adjacent column — no need to sort manually.
- Select the data range, including headers.
- Go to the Insert tab.
- In the Charts group, click Insert Statistic Chart.
- Under Histogram, choose Pareto.
- Excel automatically sorts your bars from largest to smallest and adds the cumulative percentage line on a secondary axis.
Formatting and Settings I Adjust
Once the chart is generated, here’s what I typically refine:
- Cumulative line styling: I usually thicken this line and add markers (Format Data Series > Marker Options) so the running percentage is easy to trace at each bar.
- 80% reference line: While Excel doesn’t add this automatically, I often add a horizontal reference line at 80% by creating a small helper series or using a manually drawn line shape, so viewers can instantly see which categories fall within the “vital few.”
- Axis formatting: I format the secondary (percentage) axis to display as whole percentages (0%, 20%, 40%… 100%) under Format Axis > Number.
- Bar colors: I sometimes highlight the bars that make up the top 80% in one color and the rest in a muted gray to visually separate the “vital few” from the “trivial many.”
A Practical Example
Say I’m analyzing customer complaint categories for an online store. After building the Pareto chart, I see that “Late Delivery” and “Wrong Item Shipped” together account for roughly 78% of all complaints, even though there are eight complaint categories total. That immediately tells the operations team exactly where to focus improvement efforts — fixing those two issues would resolve the vast majority of complaints, rather than spreading effort evenly across all eight categories.
Common Mistakes to Avoid
Mistakes I’ve made or seen:
- Too many categories: If you have 30+ categories, the chart becomes cramped. Consider grouping smaller categories into an “Other” bucket before charting.
- Forgetting the cumulative line’s purpose: Some people only look at the bars and ignore the line, but the cumulative percentage is what actually reveals the 80/20 breakpoint — don’t skip highlighting it.
- Using raw counts when percentages matter more: Depending on your audience, showing percentage of total rather than raw count on the bars themselves might communicate the story more effectively — you can adjust this under Format Axis for the primary axis.
- Not addressing outliers or one-off categories: A single unusual event (like one massive shipment error) might dominate the chart and skew the picture; consider whether it needs to be addressed separately.
Troubleshooting Tips
If your Pareto chart isn’t working correctly:
- “Pareto” option missing under Histogram: This chart type requires Excel 2016 or later. If you’re on an older version, you’ll need to manually sort your data and add a calculated cumulative percentage column, then build a combo chart yourself.
- Bars aren’t sorting correctly: Excel’s Pareto chart type sorts automatically — if it looks wrong, double check you didn’t accidentally select a chart type other than Pareto.
- Cumulative line looks off: Make sure there are no blank or zero-value rows in your data range, as these can distort the cumulative calculation.
- Chart is too cluttered: Reduce categories by combining the smallest ones into an “Other” group before charting.
Real-World Use Cases
I’ve used Pareto charts for:
- Manufacturing defect analysis to prioritize quality improvements
- Customer service complaint categorization to find the biggest pain points
- IT help desk ticket analysis to identify the most common issue types
- Sales analysis to find which few products generate most revenue
Best Practices
Before I finalize a Pareto chart, I always check:
- Categories are grouped sensibly, with very small ones combined into “Other” if there are too many
- The cumulative percentage line is clearly visible and easy to trace
- An 80% reference line (even if manually added) helps viewers instantly spot the cutoff point
- The chart title and axis labels clearly explain what’s being measured and why
- I’ve double-checked whether raw counts or percentages tell the story more clearly for my specific audience
Pareto charts turn the abstract 80/20 principle into a concrete, visual finding based on your actual data. Once you’ve got clean categorized data, Excel’s built-in Pareto chart type does virtually all the sorting and calculating for you — leaving you to focus on the more important part: figuring out what to actually do with that insight.
