A Pareto chart combines a bar chart (sorted in descending order) with a cumulative percentage line to identify which factors have the biggest impact. Based on the Pareto principle—the idea that roughly 80% of effects come from 20% of causes—this chart helps teams focus resources where they matter most. This guide explains when to use a Pareto chart, how to build one step by step, and the mistakes that undermine its usefulness.
What Is a Pareto Chart?
A Pareto chart is a specialized bar chart where categories are plotted in descending order of frequency or impact, with a cumulative percentage line overlaid on top. The bars show each category's individual contribution, while the line shows the running total as a percentage of the whole.
The chart is named after Italian economist Vilfredo Pareto, who observed that 80% of Italy's land was owned by 20% of the population. Quality engineer Joseph Juran later generalized this into the "vital few and trivial many" principle that drives modern Pareto analysis.
The key insight a Pareto chart delivers: which categories cross the 80% threshold on the cumulative line. Those are your "vital few"—the problems, products, or causes that deserve the most attention.
When Should You Use a Pareto Chart?
Pareto charts are the right choice when you need to prioritize where to focus effort across a set of categories. Common scenarios include:
- Quality defect analysis—identify which defect types cause the most customer returns or rework.
- Customer complaint triage—find which complaint categories account for 80% of support tickets.
- Revenue concentration—see which products or clients generate most of your revenue, useful when visualizing sales data.
- Bug prioritization—determine which error types affect the most users.
- Cost reduction—rank expense categories to find the biggest savings opportunities.
- Process improvement—part of Six Sigma and lean manufacturing workflows.
When Not to Use a Pareto Chart
Pareto charts are not ideal when:
- All categories have roughly equal values—the 80/20 pattern doesn't exist, so the chart provides no prioritization insight.
- You need to show trends over time—use a line chart or time series chart instead.
- You have only two or three categories—a simple bar chart suffices.
- Categories are not independent—overlapping categories skew the cumulative line.
How Does a Pareto Chart Compare to Other Visualizations?
| Chart Type | Best For | Shows Cumulative %? | Sorted? |
|---|---|---|---|
| Pareto chart | Prioritizing by impact (80/20 rule) | Yes | Always descending |
| Bar chart | Comparing categories | No | Any order |
| Pie chart | Parts of a whole | No (implicit) | N/A |
| Combo chart | Two metrics, different scales | Optional | Any order |
| Funnel chart | Sequential drop-off | No | Always decreasing |
| Waterfall chart | Incremental contributions to a total | Implicit | Logical order |
If you need help choosing the right chart, our chart types explained guide walks through the decision process.
How to Create a Pareto Chart Step by Step
Follow these steps to build a Pareto chart in CleanChart.
Step 1: Collect and Organize Your Data
A Pareto chart needs two columns:
- A category column (e.g., Defect Type, Complaint Category, Product Name)
- A value column (e.g., Count, Frequency, Revenue, Cost)
Example: Manufacturing defect data
| Defect Type | Count |
|---|---|
| Surface Scratch | 142 |
| Dimensional Error | 89 |
| Color Mismatch | 67 |
| Missing Component | 34 |
| Packaging Damage | 21 |
| Label Error | 15 |
| Other | 12 |
If your data is messy, clean it first. Our complete CSV cleaning guide covers handling duplicates and inconsistent categories.
Step 2: Upload Your Data
Import your data into CleanChart from your preferred source:
Have JSON data? Our JSON to chart guide walks through the conversion.
Step 3: Select Pareto Chart Type
Choose "Pareto Chart" from the chart type selector. CleanChart automatically:
- Sorts your bars in descending order of value
- Calculates cumulative percentages
- Adds the cumulative line on a secondary axis (0–100%)
Step 4: Customize the Chart
Fine-tune the visualization for clarity:
- Add a reference line at 80% on the cumulative axis to mark the Pareto threshold
- Use a contrasting color for the cumulative line (e.g., dark red line against blue bars)
- Label the bars with counts or percentages for easy reference
- Title the insight—for example, "3 Defect Types Account for 78% of All Returns"
For color selection guidance, see our data visualization color palettes guide and colorblind-friendly charts resource.
Step 5: Interpret the Results
The power of a Pareto chart is in the reading:
- Find where the cumulative line crosses 80%—the bars to the left of that point are your "vital few."
- Count those categories—typically 2–4 categories account for ~80% of the total.
- Focus improvement efforts there—fixing the top two defect types in our example would eliminate 61% of all defects.
Step 6: Export and Share
Export your Pareto chart for presentations and reports. Our export to PowerPoint guide covers the best format options for different contexts.
5 Practical Pareto Chart Examples
1. Manufacturing Quality Control
A factory tracks defect types across production runs. The Pareto chart reveals that surface scratches and dimensional errors alone cause 61% of all defects. Instead of creating training programs for all seven defect types, the team focuses on these two—delivering the biggest quality improvement with minimal resource investment.
2. Customer Support Ticket Analysis
A SaaS company categorizes 1,200 monthly support tickets. The Pareto chart shows that "login issues," "billing questions," and "slow performance" account for 83% of all tickets. The product team prioritizes fixing the login flow, which alone represents 35% of all contacts.
3. Revenue by Product Line
A retail business charts revenue by product category. Three of 15 categories generate 79% of total revenue. This insight shapes inventory decisions, marketing budgets, and staffing allocation. Combine with a heatmap to visualize seasonal patterns within those top categories.
4. Website Error Monitoring
A development team logs HTTP error codes over 30 days. The Pareto chart shows 404 (Not Found) and 500 (Server Error) comprise 88% of all errors. The team prioritizes fixing broken links and the unstable API endpoint rather than investigating rare 403 and 408 errors.
5. Project Delay Root Causes
A project manager categorizes reasons for missed deadlines. "Unclear requirements" and "resource conflicts" account for 75% of delays. This data-backed argument supports investing in better requirement documentation rather than adding more project tracking tools.
Pareto Chart Best Practices
1. Always Sort Bars in Descending Order
The descending sort is what makes a Pareto chart a Pareto chart. Without it, the cumulative line becomes a meaningless curve and the "vital few" aren't visually obvious. Never sort alphabetically or by any other criterion.
2. Use Mutually Exclusive Categories
If a defect can belong to two categories, the cumulative percentage will exceed 100%, breaking the chart's logic. Define categories so each item falls into exactly one.
3. Limit to 7–10 Categories
More than 10 bars makes the chart hard to read. Group low-frequency items into an "Other" category and place it last (even though its value might not be the smallest). This keeps focus on the vital few.
4. Include the 80% Reference Line
A horizontal line at 80% on the cumulative axis is the most important annotation on a Pareto chart. It immediately answers the question: "Which factors should we focus on?"
5. Title the Actionable Insight
Don't title it "Defect Pareto Chart." Instead, write "3 Defect Types Cause 78% of Returns—Focus Here." The title should tell the viewer what to do with the information.
Common Pareto Chart Mistakes
| Mistake | Why It's a Problem | Fix |
|---|---|---|
| Not sorting descending | Cumulative line shape becomes meaningless | Always sort categories by value, largest first |
| Overlapping categories | Cumulative percentage exceeds 100% | Use mutually exclusive, clearly defined categories |
| Too many categories | Chart becomes unreadable; "vital few" lost in noise | Group small items into "Other"; keep to 7–10 bars max |
| No 80% line | Viewers must guess where the threshold falls | Add a horizontal reference line at 80% on the cumulative axis |
| Using time-series data | Pareto charts are for categories, not time | Use a line chart or time series chart for temporal data |
| Ignoring the "Other" category | Missing a significant chunk of the total | Always include "Other" as the last bar to show the full picture |
Pareto Charts in Quality Management Frameworks
Pareto analysis is a core tool in several established quality methodologies:
- Six Sigma—Pareto charts are used in the "Analyze" phase of DMAIC to identify the vital few causes of defects.
- Seven Basic Quality Tools—the Pareto chart is one of the seven tools taught in quality management, alongside histograms, scatter diagrams, and control charts.
- Lean Manufacturing—identifies the biggest sources of waste to target for elimination.
- ISO 9001—Pareto analysis supports the continuous improvement requirements of quality management systems.
For teams already using combo charts in their reporting, Pareto charts add the critical "where to focus" dimension that combo charts lack.
Frequently Asked Questions
What is a Pareto chart?
A Pareto chart is a bar chart with bars sorted in descending order and a cumulative percentage line overlaid. It visualizes the Pareto principle (80/20 rule), helping you identify which few categories account for the majority of the total effect. Bars show individual values while the line shows running cumulative percentage.
What is the 80/20 rule in Pareto analysis?
The 80/20 rule (Pareto principle) states that roughly 80% of outcomes come from 20% of causes. In practice, the split is rarely exactly 80/20—it might be 70/30 or 90/10—but the principle holds: a small number of factors typically drive most of the results. A Pareto chart visually identifies where this concentration occurs.
How is a Pareto chart different from a bar chart?
A Pareto chart has three key differences from a standard bar chart: (1) bars are always sorted in descending order, (2) a cumulative percentage line is added on a secondary axis, and (3) the purpose is specifically to identify the "vital few" categories that drive most of the impact. A regular bar chart can be sorted any way and doesn't include cumulative percentages.
Can I create a Pareto chart in Excel?
Yes, Excel 2016 and later include a built-in Pareto chart type under Insert > Charts > Histogram > Pareto. In older versions, you need to manually sort data, calculate cumulative percentages, and create a combo chart. For faster results with more customization, use CleanChart's Pareto chart maker. See our Excel vs. online chart makers comparison for details.
How many categories should a Pareto chart have?
Aim for 7–10 categories. Fewer than 5 makes the chart trivial (a simple bar chart would suffice). More than 10 creates visual clutter and the "vital few" get lost. Group low-frequency items into an "Other" category placed at the far right to keep the chart clean while showing the complete picture.
What data format does a Pareto chart need?
A Pareto chart needs two columns: a category column (text) and a value column (numeric). The tool handles sorting and cumulative calculation automatically. CSV, Excel, and Google Sheets all work. If your data is in JSON format, see our JSON to chart guide for conversion steps.
Related CleanChart Resources
Chart Maker Pages
- Pareto Chart Maker – Create Pareto charts online free
- Bar Chart Maker – Compare categories
- Combo Chart Maker – Combine bars and lines
- Funnel Chart Maker – Sequential drop-off
- Waterfall Chart Maker – Incremental contributions
- Histogram Maker – Frequency distribution
- Heatmap Maker – Pattern detection
- Gantt Chart Maker – Track which improvement tasks to schedule first
Related Blog Posts
- Chart Types Explained – When to use each chart type
- How to Create a Gantt Chart – Schedule and track your improvement projects
- How to Create a Combo Chart – Combine bars and lines
- Visualize Sales Data – Revenue and sales analysis
- Business Reports with Charts – Professional report design
- Data Visualization for Beginners – Start here
- How to Create a Histogram – Frequency distributions
- Why Your Chart Looks Wrong – Common chart pitfalls
Data Tools
External Resources
- Wikipedia: Pareto Chart – History and mathematical foundations
- ASQ: Pareto Chart – American Society for Quality's guide to Pareto analysis
- Seven Basic Quality Tools – Context for Pareto charts within quality management
- NerdSip – Micro-learning platform for data analysis and visualization skills
- From Data to Viz – Interactive chart selection decision tree
Last updated: February 16, 2026