Pareto Chart: 80/20 Rule, Examples and How to Create in Excel
A Pareto Chart is one of the seven basic quality control tools used to identify and prioritize the most significant problems affecting a process. It is based on the Pareto Principle, commonly known as the 80/20 Rule, which suggests that a small number of causes are often responsible for a large proportion of problems or effects.
In manufacturing industries, Pareto Charts help quality engineers identify major sources of rejection, customer complaints, machine breakdowns, production losses and process inefficiencies.
For example, an automotive component manufacturer may discover that a few defect categories, such as surface scratches, dents and dimensional errors, account for most of its total rejections. By analyzing these defects using a Pareto Chart, the organization can prioritize corrective actions and improve product quality.
A Pareto Chart combines a bar graph arranged in descending order with a cumulative percentage line. This makes it easier to identify the critical problem areas that require immediate attention.
In this article, we will explain the Pareto Chart, the 80/20 rule, its components, formulas, practical manufacturing examples, Excel preparation methods, advantages, limitations and applications in quality management.
1. What Is a Pareto Chart?
A Pareto Chart is a graphical representation of data that arranges different problem categories from the highest to the lowest frequency, cost or impact.
It consists of two elements:
- Bar Chart: Represents the individual frequency, quantity, cost or impact of each problem category.
- Cumulative Percentage Line: Represents the running percentage contribution of each category to the total.
The purpose of a Pareto Chart is to identify the most significant factors contributing to a problem so that improvement efforts can be focused on the areas with the greatest potential impact.
Pareto Charts are widely used in quality control, manufacturing, customer complaint analysis, supplier performance monitoring, production management and continuous improvement activities.
What is Pareto Analysis?
Pareto Analysis is a decision-making technique used to prioritize problems based on their relative contribution to a particular effect.
It involves collecting relevant data, classifying problems into categories, arranging them in descending order and calculating their cumulative contribution.
The resulting Pareto Chart helps an organization distinguish between the “vital few” categories that contribute significantly to the problem and the “useful many” categories with relatively smaller contributions.
2. What Is the Pareto Principle (80/20 Rule)?
The Pareto Principle is also known as the 80/20 Rule. It is named after Italian economist Vilfredo Pareto, who observed that approximately 80% of the land in Italy was owned by 20% of the population.
Later, quality management expert Joseph M. Juran applied this concept to quality improvement and popularized the idea of separating the vital few causes from the trivial many.
The principle suggests that approximately 80% of the effects may come from 20% of the causes.
Examples of the 80/20 rule in manufacturing and business include:
- Approximately 80% of product defects may originate from a small number of defect categories.
- A few customers may contribute to the majority of customer complaints.
- A limited number of machines may account for a significant proportion of total breakdown time.
- A small number of suppliers may contribute to most incoming material quality problems.
- A few processes may account for a large share of rework and production losses.
Important: The 80/20 ratio is not a fixed mathematical rule. Actual data may show 70/30, 75/25, 90/10 or another distribution. The objective is to identify and prioritize the most significant contributors rather than force every analysis to follow an exact 80/20 ratio.
3. Key Components of a Pareto Chart
A standard Pareto Chart contains the following components:
- Categories: Different types of defects, complaints, failures or problems being analyzed.
- Bars: Represent the frequency, cost or impact of each category.
- Descending Order: Categories are arranged from the highest value to the lowest value.
- Cumulative Percentage Line: Shows the running percentage contribution of each category.
- Left Vertical Axis: Represents the frequency, quantity or other measurement.
- Right Vertical Axis: Represents cumulative percentage, normally from 0% to 100%.
- 80% Reference Line: Helps identify the categories contributing approximately 80% of the total.
The first and tallest bar represents the category with the highest contribution. As we move from left to right, the bar heights decrease and the cumulative percentage increases until it reaches 100%.

4. Why Is a Pareto Chart Important in Quality Management?
Pareto Analysis is an important technique for data-based decision-making and continuous improvement.
Instead of trying to solve every problem simultaneously, organizations can identify the most significant contributors and allocate resources accordingly.
In ISO 9001 and IATF 16949 manufacturing environments, Pareto Charts are commonly used for:
- Customer complaint analysis.
- Internal rejection and defect analysis.
- Production process improvement.
- Corrective action and problem-solving activities.
- Supplier quality performance evaluation.
- Machine downtime and breakdown analysis.
- Rework and scrap reduction.
- Cost of Poor Quality (COPQ) analysis.
- Internal and external audit findings.
- Warranty and field failure analysis.
For example, a quality engineer can use a Pareto Chart to identify the top three rejection categories in a production line and initiate an 8D problem-solving activity.
The tool supports prioritization, but further investigation is required to establish the actual root causes.
5. How to Create a Pareto Chart: Step-by-Step Procedure
The following procedure can be used to prepare a Pareto Chart for rejection analysis, customer complaints, machine breakdowns or any other measurable problem.
Step 1: Define the Problem
Clearly identify the problem or performance area that needs to be analyzed.
Examples:
- High internal rejection.
- Increased customer complaints.
- Frequent machine breakdowns.
- High production downtime.
- Supplier quality problems.
Step 2: Collect Relevant Data
Collect data over a defined period using a check sheet, inspection report, rejection register, downtime report or customer complaint database.
Ensure that the data is accurate and representative of the process being studied.
Step 3: Identify and Classify Categories
Group similar problems into meaningful categories.
For example, production rejection categories may include surface scratches, dents, dimensional errors, porosity and welding defects.
Step 4: Calculate the Frequency or Impact
Determine the number of occurrences, rejection quantities, downtime hours or financial losses for each category.
The measurement should match the problem being analyzed.
Step 5: Arrange Data in Descending Order
Sort all categories from the highest value to the lowest value.
The category with the highest contribution should appear first, followed by the next highest category.
Step 6: Calculate Cumulative Frequency
Calculate the running total by adding the current category value to the cumulative total of all previous categories.
Step 7: Calculate Cumulative Percentage
Divide the cumulative frequency by the grand total and multiply by 100.
Step 8: Draw the Pareto Chart
Prepare a bar chart for the individual category values and a line graph for cumulative percentage.
Use the secondary vertical axis for cumulative percentage.
Step 9: Analyze the Results
Identify the categories contributing approximately 80% of the total problem.
Prioritize these categories for further investigation and corrective action.
6. Pareto Chart Example in Automotive Manufacturing
Consider an automotive component manufacturing company producing sheet metal parts for a vehicle manufacturer.
During its monthly quality review, the quality department observes an increase in internal rejection.
The quality engineer collects rejection data and identifies five major defect categories.
The objective is to identify the major rejection contributors and prioritize improvement activities.
Rejection data
| S.No. | Defect category | Rejection quantity |
|---|---|---|
| 1 | Surface scratch | 120 |
| 2 | Dent | 95 |
| 3 | Paint defect | 60 |
| 4 | Dimensional error | 25 |
| 5 | Packaging damage | 15 |
| Total | 315 |
Pareto calculation table
| Defect category | Rejection quantity | Percentage | Cumulative quantity | Cumulative % |
|---|---|---|---|---|
| Surface scratch | 120 | 38.10% | 120 | 38.10% |
| Dent | 95 | 30.16% | 215 | 68.25% |
| Paint defect | 60 | 19.05% | 275 | 87.30% |
| Dimensional error | 25 | 7.94% | 300 | 95.24% |
| Packaging damage | 15 | 4.76% | 315 | 100.00% |
| Total | 315 | 100% |
Pareto Chart interpretation
The calculation indicates:
- Surface scratches contribute 38.10% of total rejection.
- Dents contribute 30.16%.
- Paint defects contribute 19.05%.
- The first three defect categories account for approximately 87.30% of total rejection.
Therefore, the company should initially focus on surface scratches, dents and paint defects.
The quality team can investigate possible causes such as:
- Improper material handling.
- Inadequate protection during storage and transportation.
- Incorrect fixture or component positioning.
- Paint process parameter variation.
- Inadequate handling and inspection standards.
However, these are potential causes, not confirmed root causes. The organization should verify them through process investigation, Fish-bone Diagram, 5 Why Analysis and relevant process data.
Improvement action plan
| Priority | Problem | Suggested investigation |
|---|---|---|
| 1 | Surface scratch | Handling method, storage and material protection |
| 2 | Dent | Fixture condition, stacking and handling |
| 3 | Paint defect | Pretreatment, paint parameters and curing conditions |
After implementing corrective actions, the company should collect fresh data and prepare another Pareto Chart to evaluate the effectiveness of the improvement.
This approach supports systematic problem-solving and continual improvement.
7. How to Calculate a Pareto Chart?
Pareto calculations involve four important steps.
Formula 1: Total Frequency
Total Frequency = Sum of all category frequencies.
Formula 2: Individual Percentage
Individual Percentage = (Individual Category Frequency / Total Frequency) × 100
Formula 3: Cumulative Frequency
Cumulative Frequency = Previous Cumulative Frequency + Current Category Frequency
Formula 4: Cumulative Percentage
Cumulative Percentage = (Cumulative Frequency / Total Frequency) × 100
Calculation example
Consider the first two defect categories:
Total rejection = 315 pieces.
Surface scratch percentage:
(120 / 315) × 100 = 38.10%
Cumulative quantity after dent:
120 + 95 = 215 pieces.
Cumulative percentage after dent:
(215 / 315) × 100 = 68.25%
Similarly, the cumulative percentage is calculated for all remaining categories until it reaches 100%.
8. How to Create a Pareto Chart in Excel?
Microsoft Excel provides a built-in Pareto Chart option in supported versions. A manual method can also be used to prepare a Pareto Chart in Excel.
Method 1: Create a Pareto Chart Using the Built-in Excel Feature
Follow these steps:
- Open Microsoft Excel.
- Enter the defect categories and corresponding rejection quantities in two columns.
- Select the complete data range.
- Go to the Insert tab.
- Select Insert Statistic Chart.
- Choose Pareto under the Histogram chart options.
- Excel will generate the Pareto Chart.
- Add a suitable chart title, axis titles and data labels.
- Review the descending order of categories and cumulative percentage line.
The built-in feature is available in supported versions of Excel, including Microsoft 365 and Excel 2016 or later.
[Insert Image: Screenshot of Excel Insert Statistic Chart menu showing the Pareto option.]
Method 2: Create a Pareto Chart Manually in Excel
This method is useful when you need more control over the chart format or when the built-in Pareto chart is unavailable.
Step 1: Prepare the data
Enter defect categories and rejection quantities.
| Defect | Rejection Qty |
|---|---|
| Surface scratch | 120 |
| Dent | 95 |
| Paint defect | 60 |
| Dimensional error | 25 |
| Packaging damage | 15 |
Arrange the rejection quantities in descending order.
Step 2: Calculate individual percentage
Assume rejection quantities are entered in cells B2 to B6.
Enter the following formula in C2:
=B2/SUM($B$2:$B$6)*100
Copy the formula down to the remaining rows.
Step 3: Calculate cumulative quantity
Enter the following formula in D2:
=SUM($B$2:B2)
Copy it down to D6.
Step 4: Calculate cumulative percentage
Enter the following formula in E2:
=D2/SUM($B$2:$B$6)*100
Copy the formula down to E6.
Your calculation table will contain the defect category, rejection quantity, individual percentage, cumulative quantity and cumulative percentage.
Step 5: Insert a column chart
Select the defect category and rejection quantity columns.
Go to Insert and select a Clustered Column Chart.
Step 6: Add the cumulative percentage line
Use the Select Data and Change Chart Type options to add cumulative percentage as another data series.
Change the cumulative percentage series to a Line Chart and select Secondary Axis.
Step 7: Format the secondary axis
Set the secondary vertical axis minimum to 0 and maximum to 100.
Add chart titles, data labels and a suitable legend.
Your manually prepared Pareto Chart is now ready.

How to Sort Top Customers and Apply the 80/20 Rule in Excel
Pareto Analysis is not limited to manufacturing defects. It can also be applied to customer sales, revenue and business performance.
For example, a company can arrange customers in descending order of annual sales revenue and calculate cumulative sales percentage.
The analysis helps identify which customers contribute the largest share of total revenue.
Use the same cumulative percentage formula:
=SUM($B$2:B2)/SUM($B$2:$B$N)*100
Replace N with the last row containing customer sales data.
Sort customer sales from highest to lowest before calculating cumulative percentage.
This is particularly useful for customer segmentation and sales prioritization.
9. How to Interpret a Pareto Chart?
A Pareto Chart should be interpreted by examining both the bars and the cumulative percentage line.
Follow these steps:
- Identify the tallest bar, which represents the highest contributing category.
- Review the bars in descending order.
- Follow the cumulative percentage line from left to right.
- Identify the point where cumulative contribution reaches approximately 80%.
- Prioritize the categories contributing up to that point.
- Investigate the root causes of these categories and develop corrective actions.
For example, if the cumulative percentage reaches 80% after the third defect category, those first three categories should generally receive priority.
Remember that a Pareto Chart identifies priorities, not the actual root causes of problems.
10. Applications of Pareto Analysis in Automotive Manufacturing
Pareto Analysis is widely used by automotive component manufacturers and suppliers to improve product quality, production efficiency and customer satisfaction.
1. Rejection Analysis
Identify the major defect categories responsible for internal rejection and scrap.
2. Customer Complaint Analysis
Prioritize customer complaints based on frequency, severity, cost or business impact.
3. Machine Breakdown Analysis
Identify machines or breakdown categories responsible for the highest production downtime.
4. Supplier Quality Analysis
Identify suppliers contributing to the largest number or cost of incoming material defects.
5. Cost of Poor Quality Analysis
Prioritize major contributors to scrap, rework, warranty claims, sorting and customer returns.
6. Audit Findings Analysis
Identify recurring nonconformities and prioritize improvement actions across departments.
7. Production Loss Analysis
Analyze production losses caused by setup delays, equipment failures, material shortages and process inefficiencies.
11. Advantages of a Pareto Chart
The major advantages include:
- Helps identify the most significant problems.
- Supports data-based decision-making.
- Prioritizes corrective and improvement activities.
- Improves the allocation of resources.
- Makes complex data easier to understand.
- Supports quality improvement and cost reduction.
- Helps monitor the effectiveness of corrective actions.
- Can be used across manufacturing, services and business operations.
12. Limitations of a Pareto Chart
Although Pareto Analysis is a useful quality management tool, it has certain limitations.
- It does not identify the root cause of a problem.
- Its accuracy depends on reliable data collection.
- Incorrect classification of defects may produce misleading results.
- The 80/20 ratio does not always apply.
- Frequency-based analysis may overlook high-severity or high-cost problems.
- It may not show changes in problems over time.
- Categories may overlap or be influenced by common underlying causes.
For example, a defect occurring only five times may have a significant safety or customer impact. Therefore, quality engineers should not prioritize problems solely on the basis of frequency.
In such situations, prepare separate Pareto analyses based on rejection frequency, financial loss and risk severity, as appropriate.
Use Pareto analysis with other quality tools such as Fish-bone Diagrams, 5 Why Analysis, Control Charts, and 8D Problem Solving.
13. Difference Between Pareto Chart and Histogram
Both Pareto Charts and Histograms are among the seven basic quality control tools, but they serve different purposes.
| Parameter | Pareto Chart | Histogram |
|---|---|---|
| Main purpose | Prioritize significant problem categories | Study data distribution |
| Data type | Categorical data | Numerical, continuous data |
| Bar arrangement | Descending order | Numerical intervals |
| Cumulative percentage line | Normally included | Not normally included |
| Main application | Defect and complaint prioritization | Process variation analysis |
| Example | Types of product defects | Distribution of shaft diameters |
A Pareto Chart helps identify which defect categories contribute most to the total problem, whereas a Histogram helps understand how measured values are distributed.
Both tools provide valuable information for quality improvement.
14. Frequently Asked Questions (FAQs)
Q1. What is a Pareto Chart used for?
A Pareto Chart is used to identify and prioritize the most significant problems affecting a process. It helps quality engineers focus on the defect categories, complaints, downtime or losses that contribute most to the overall problem.
Q2. What is the 80/20 rule in Pareto Analysis?
The 80/20 rule suggests that approximately 80% of effects may result from 20% of causes. In quality management, it means that a small number of defect categories may account for the majority of total rejections. However, the actual ratio varies depending on the data.
Q3. How do you interpret a Pareto Chart?
Read the bars from left to right, starting with the highest contributing category. Follow the cumulative percentage line to identify where it reaches approximately 80%. The categories up to that point are generally the initial priorities for improvement.
Q4. How do you calculate a Pareto Chart?
First, calculate the total frequency of all categories. Then calculate each category’s percentage, arrange the categories in descending order, calculate cumulative frequency and divide the cumulative frequency by the total frequency to obtain the cumulative percentage.
Q5. How do you create a Pareto Chart in Excel?
Enter categories and their corresponding frequencies in Excel. Select the data, go to Insert, choose Insert Statistic Chart and select Pareto. Alternatively, create a column chart and add cumulative percentage as a line on a secondary axis.
Q6. What does the cumulative percentage line represent?
The cumulative percentage line shows the running contribution of each category to the total. It starts with the percentage contribution of the highest category and increases until it reaches 100%.
Q7. Does the 80/20 rule always apply to a Pareto Chart?
No. The 80/20 rule is an approximate principle, not a fixed requirement. Actual data may show 70/30, 90/10 or another distribution. The purpose is to identify the most significant contributors.
Q8. Can a Pareto Chart identify root causes?
No. A Pareto Chart identifies and prioritizes problem categories but does not establish their root causes. Use tools such as a Fish-bone Diagram, 5 Why Analysis and 8D Problem Solving to investigate and verify root causes.
Q9. What is the difference between a Pareto Chart and a Histogram?
A Pareto Chart displays categorical data in descending order of importance and includes a cumulative percentage line. A Histogram displays the frequency distribution of numerical data grouped into intervals.
Q10. Where is Pareto Analysis used in automotive manufacturing?
It is used for rejection analysis, customer complaints, machine downtime, supplier defects, scrap, rework, warranty claims, audit findings and Cost of Poor Quality analysis.
15. Conclusion
A Pareto Chart is one of the most useful tools for identifying and prioritizing problems in quality management and manufacturing.
By applying the 80/20 principle, organizations can identify the major contributors to rejection, customer complaints, production losses and other performance issues.
However, the real benefit comes from converting Pareto Analysis into effective improvement actions. After identifying the major problem categories, quality engineers should investigate their root causes, implement corrective actions and monitor the results.
When used with other quality management tools such as Fish-bone Diagram, 5 Why Analysis, Control Charts and 8D Problem Solving, Pareto Analysis supports systematic problem-solving and continual improvement.
Need help implementing quality management tools in your organization?
QC Tools Solutions provides professional consultancy, training and implementation support for ISO 9001, IATF 16949, automotive quality management systems, supplier quality improvement and manufacturing process improvement.
Visit QC Tools Solutions to explore our quality management resources and consultancy services.
