Many of us have heard about the term Pareto Analysis or Pareto Chart or 80-20 rule. But, what is the meaning of it? And how to use it in our day to day life?
This article explains about the Benefits of Pareto analysis, How to use it with Demonstration and how we can utilise it in our daily activities.
First of all we will see the history of Pareto chart:
History of Pareto chart
Origin: The principle of Pareto goes way back to 1897, when Vilfredo Pareto used the 80-20 rule to represent the distribution of wealth in Italy. He observed that 20% of Italian population possesses 80% of the Land and wealth of the country.
Later on, Joseph M. Juran named the principle “PARETO” after the Italian economist Vilfredo Pareto in 1941.
Pareto Chart is one of the 7 tools of the Quality Management.
Different names of Pareto analysis
- Pareto Principle
- 80-20 rule
- Law of the vital few
- Principle of factory sparsity
Principle of Pareto Analysis
It states that the 80% of problems/effect are caused by 20% of the causes. In short, the purpose of the chart is to find the most important/critical factor from the set of many other factors.
Examples:
- 80% of manufacturing defect comes by 20% of human error
- 80% of road accidents occurs by 20% of drivers
- 80% wealth belongs to 20% of population
- 20% employee contributes to 80% of revenue
- 20% of time spent on work gives 80% results
Benefits of Pareto Analysis
- Separate the problem and causes
- Helps to focus on the right problems
- Enhance the decision making skills
- Improves problem solving skills
- Increases the efficiency of work
- Saves time
Now that we know the principle and benefits of it, let us see how to prepare the Pareto chart and what the data that needs to be collected are.
How to make Pareto chart
Pareto chart is prepared majorly in Microsoft Excel and Minitab.
We will illustrate the chart in Microsoft excel.
Let us take an example of a printing press. So, there is a printing press and during the process of printing, there are various defects that occurs on the paper.
Step 1
The first step will be to collect the data of all the defects and the number of time it occurs on paper in one set of operation. Example is shown in table below.
| Problem category | Number of occurrence |
| Cross Printing | 13 |
| Dusty spot on paper roller | 23 |
| Folded edges | 180 |
| Incorrect shade | 79 |
| Ink Adjustment | 12 |
| Multiple units colour adjustment | 7 |
| Torn piece of paper on roll | 41 |
| Wrinkles | 14 |
| Total | 369 |
As shown in the above table, there are various defects that occurred during the printing of paper and in the other column there are Number of Occurrence i.e. the total number of time it occurred on the paper.
Note: Number of occurrence can also be named as frequency
Step 2
The next step will be to arrange the Occurrence in descending order and make other two column of Cumulative and Cumulative percentage
| Problem Category | Occurrence | Cumulative | %Cumulative |
| Folded edges | 180 | 180 | 49% |
| Incorrect shade | 79 | 259 | 70% |
| Torn piece of paper on roll | 41 | 300 | 81% |
| Dusty spot on paper roller | 23 | 323 | 88% |
| Wrinkles | 14 | 337 | 91% |
| Cross Printing | 13 | 350 | 95% |
| Ink Adjustment | 12 | 362 | 98% |
| Multiple units colour adjustment | 7 | 100% | |
| Total |
To calculate cumulative numbers, we have to add each occurrence from occurrence table to the sum of its predecessors.
Example: The first number i.e. 180 (in cumulative column) will remain same, while the second number 259 = 180 (in cumulative column) + 79 (Incorrect shades) and again 300 = 259 (cumulative number) + 41 (Torn piece of paper) and so on.
Note: The last number in cumulative column will always be same as the total number of occurrence. In this case 369 is the number which will be same in final cumulative column as well as total occurrences.
Similarly, also calculate the % cumulative.
To calculate cumulative percentage: Cumulative number/Total number of occurrence
For example: for, 49% = 180/369 and so on.
Step 3
The next step will be to prepare Pareto chart. Go to Insert – select column chart. After clicking on the column chart, white chart space will open. Right click on it and ‘Select data’. After clicking on select data, the below screen will occur.

Select the column of ‘Problem category’ and ‘Occurrence’ together. Insert comma (,) in Chart data range and select ‘Cumulative percentage’ column.

Your Pareto chart will be displayed like the above image.
Step 4
Now that the main Pareto chart is prepared, it is time to edit and make it more visible and easy to understand.
Right click on the red %cumulative and click on “Change series chart type”. After clicking on it, a new dialog box will open. In the drop down in front of %cumulative choose “line with marker” and then click OK

Step 5
After the above step, right click on the red line in the chart and click on “Format data labels” and select secondary axis.

The above image shows the almost completed Pareto chart. You can right click on the blue columns and add labels and also edit the position of it. Also you can do same for %cumulative axis by right clicking and add labels. One can easily change colour, font size and position of the numbers
Step 6
The next step will be to display the defects which contributes to the 80% of the problems, for that go to Insert- shape and select any suitable shape and highlight the chart up till 80%.

One can easily see in the above chart that 80% problems are highlighted as “Vital few”, meaning three main defects are contributing to the 80% of the problems in the printing press.
The next step will be to do brainstorming, analyse the problem and get suitable solution using Root cause analysis.
Pareto charts in Excel
You can download the pareto chart excel template here.
Thank you
If you know any subject that can be related to manufacturing industry or industrial engineering, you can earn some income by becoming article contributor of this website. For knowing more about it, please visit Join us page.
You don’t need to have any experience in article writing, just knowledge on the subject is needed.
Also you can know more about our team of article contributors by visiting the about us page.
About the Author

Jay Desai has over 4 years of experience in Lean Six Sigma, Operations Management and Production Engineering. A post graduate in Computer Integrated Manufacturing from Nirma University. He has successfully delivered Lean deployment, training and project coaching at many levels within customers organization as well as delivered educational programmes.
Latest articles from Know Industrial Engineering
- Soft Skills Series:Problem-SolvingWhat is Problem-Solving? Problem-solving is the ability to identify an issue, understand its actual cause, and find an effective solution. In manufacturing, addressing the root cause rather than repeatedly correcting the same issue helps prevent recurring problems and improve operational efficiency. Advertisement Example from a Factory A production line experiences repeated defects because components are… Read more: Soft Skills Series:Problem-Solving
- Supplier Lead Time Variability: Why Do Some Materials Arrive Late?What is Supplier Lead Time Variability? Supplier Lead Time Variability refers to the difference between the expected delivery time and the actual delivery time of materials from suppliers. Advertisement Even when a supplier promises a fixed delivery period, actual deliveries may vary because of production delays, transportation issues, material shortages, or other disruptions. Simple Factory… Read more: Supplier Lead Time Variability: Why Do Some Materials Arrive Late?
- KIE Factory Stories: Why Did the Manager Ask the Operator to Work Less?“Your output is excellent. But I want you to slow down.” The operator looked confused. Advertisement He was one of the fastest workers in the factory. He regularly exceeded his production target and rarely took breaks. So why was the manager asking him to work less? The manager had noticed something during a factory visit.… Read more: KIE Factory Stories: Why Did the Manager Ask the Operator to Work Less?
- Process Validation: Ensure a Manufacturing Process Can Consistently Produce Quality ProductsWhat is Process Validation? Process Validation is the documented activity of confirming that a manufacturing process can consistently produce products that meet specified quality requirements. Advertisement It provides evidence that the process works as intended under defined operating conditions. Simple Factory Example An electronics manufacturer introduces a new soldering process for PCB assembly. Before starting… Read more: Process Validation: Ensure a Manufacturing Process Can Consistently Produce Quality Products
- Soft Skills Series:TeamworkWhat is Teamwork? Teamwork is the ability to work cooperatively with others to achieve a common goal. In manufacturing, production, quality, maintenance, and stores departments depend on one another. Effective teamwork helps departments coordinate their activities and solve problems efficiently. Advertisement Example from a Factory The production department is unable to complete its daily target… Read more: Soft Skills Series:Teamwork
- Quality at Source: Prevent Defects Instead of Passing Them ForwardWhat is Quality at Source? Quality at Source means ensuring that every worker checks the quality of their own work at the point where the work is performed. Advertisement Instead of depending only on the final inspection team, defects are identified and corrected immediately at the process where they occur. Simple Factory Example Imagine an… Read more: Quality at Source: Prevent Defects Instead of Passing Them Forward
- KIE Factory Stories: Why Did the Quality Manager Ask for More Defects?“We are trying to reduce defects. Why are you asking the team to report more of them?” The Production Manager was confused. Advertisement The Quality Manager had introduced a new rule. Every operator had to report even the smallest defect, including parts that could be repaired immediately. Within a week, the defect report showed a… Read more: KIE Factory Stories: Why Did the Quality Manager Ask for More Defects?
- Soft Skills Series:AdaptabilityWhat is Adaptability? Adaptability is the ability to adjust to new situations, changing priorities, and unexpected challenges without losing focus on work objectives. In manufacturing, production plans, customer requirements, and machine conditions can change frequently. Employees must be willing to learn and adjust their approach. Advertisement Example from a Factory A production planner receives an… Read more: Soft Skills Series:Adaptability
- Critical to Quality (CTQ): Understand What Matters Most to Your CustomerWhat is Critical to Quality (CTQ)? Critical to Quality refers to the measurable product or service characteristics that are most important to customers. Advertisement It helps manufacturers convert customer expectations into specific quality requirements that can be measured and controlled. Simple Factory Example A company manufactures electrical connectors. Customers expect: Listen 0:00 / —:— The… Read more: Critical to Quality (CTQ): Understand What Matters Most to Your Customer
- KIE Factory Stories: Why Did the Quality Manager Ask for More Defects?“We are trying to reduce defects. Why are you asking the team to report more of them?” The Production Manager was confused. Advertisement The Quality Manager had introduced a new rule. Every operator had to report even the smallest defect, including parts that could be repaired immediately. Within a week, the defect report showed a… Read more: KIE Factory Stories: Why Did the Quality Manager Ask for More Defects?
- Soft Skills Series:Time ManagementWhat is Time Management? Time management is the ability to plan, prioritize, and complete tasks within the available time. In manufacturing, managing time effectively helps employees meet production schedules, avoid unnecessary delays, and maintain workflow efficiency. Advertisement Example from a Factory A maintenance technician receives three machine breakdown requests during a shift. One machine has… Read more: Soft Skills Series:Time Management
- Why Do Factory Problems Keep Coming Back Even After Corrective Actions?A factory faces a recurring machine breakdown. The maintenance team investigates the issue, replaces a damaged component, and closes the corrective action report. Advertisement Problem solved! Two weeks later, the same machine breaks down again. Another investigation. Another corrective action. Another report. But why does the problem keep returning? Listen 0:00 / —:— Because fixing… Read more: Why Do Factory Problems Keep Coming Back Even After Corrective Actions?
- Milk Run: Improve Material Delivery Inside a FactoryWhat is a Milk Run? A Milk Run is a planned material collection and delivery system in which one vehicle follows a fixed route and schedule to collect or deliver materials at multiple locations. Advertisement Instead of sending separate vehicles for every material request, factories use one planned route to serve several workstations. Simple Factory… Read more: Milk Run: Improve Material Delivery Inside a Factory
- Soft Skills Series:AccountabilityWhat is Accountability? Accountability means accepting responsibility for your tasks, actions, and results. Advertisement It involves completing assigned work, acknowledging mistakes, and taking appropriate action to correct them rather than blaming others. Example from a Factory A quality inspector discovers that a batch of finished products was not inspected before being transferred to the packing… Read more: Soft Skills Series:Accountability
- KIE Factory Stories: Why Did the Factory’s Most Expensive Machine Sit Idle for Three Hours?“We have invested ₹2 crore in this machine. Why is nobody using it?” The Plant Head was furious. Advertisement The machine was fully operational. Operators were available. Production orders were waiting. Yet the machine had been sitting idle for three hours. Listen 0:00 / —:— The Maintenance Manager blamed Production. Production blamed Quality. Quality blamed… Read more: KIE Factory Stories: Why Did the Factory’s Most Expensive Machine Sit Idle for Three Hours?
- Why Do Kaizen Improvements Disappear After a Few Months?A manufacturing company conducts a Kaizen project. Production increases from 800 to 950 units per shift. Advertisement Everyone celebrates the improvement. But three months later, production drops to 830 units. What went wrong? The improvement was implemented, but it was never properly sustained. Listen 0:00 / —:— Operators returned to old methods. New employees were… Read more: Why Do Kaizen Improvements Disappear After a Few Months?
- Scatter Diagram: Identify Relationships Between Two Variables in ManufacturingWhat is a Scatter Diagram? A Scatter Diagram is a quality improvement tool used to study the relationship between two variables. Advertisement It displays data points on a graph to help engineers identify whether changes in one variable are associated with changes in another. Simple Factory Example A manufacturing engineer wants to understand whether machine… Read more: Scatter Diagram: Identify Relationships Between Two Variables in Manufacturing
- Soft Skills Series : Clear CommunicationWhat is Clear Communication? Clear communication means sharing information in a simple, accurate, and understandable manner. In manufacturing, effective communication helps prevent misunderstandings, reduce errors, and ensure smooth coordination between departments. Advertisement Example from a Factory A production supervisor needs to communicate a daily production target to an operator. Poor Response: “Increase production. We need… Read more: Soft Skills Series : Clear Communication
- KIE Factory Stories: Why Did the Operator Refuse a Promotion?“We want to make you a line supervisor.” The Production Manager was surprised by the answer. Advertisement “No, sir. I would prefer to remain an operator.” The operator had 12 years of experience. He was highly skilled, respected by his colleagues and consistently delivered excellent results. The manager couldn’t understand his decision. Listen 0:00 /… Read more: KIE Factory Stories: Why Did the Operator Refuse a Promotion?
- Histogram: Understand the Distribution of Quality DataWhat is a Histogram? A Histogram is a graphical tool used to show how frequently different values occur within a set of data. Advertisement In manufacturing, it helps engineers understand process variation and identify whether production measurements are consistent or widely spread. Simple Factory Example A quality inspector measures the diameter of 50 manufactured metal… Read more: Histogram: Understand the Distribution of Quality Data
- KIE Factory Stories: Why Did the Factory Make 10,000 Extra Parts That Nobody Ordered?“Where did these 10,000 components come from?” The Finance Manager was staring at the inventory report. Advertisement The Production Manager checked the schedule. Every production order had been completed correctly. The machines had performed well. The operators had met their targets. Listen 0:00 / —:— So why was the factory holding so many extra components?… Read more: KIE Factory Stories: Why Did the Factory Make 10,000 Extra Parts That Nobody Ordered?
- Check Sheet: A Simple Tool for Collecting Quality Data in ManufacturingWhat is a Check Sheet? A Check Sheet is a structured form used to collect and record data systematically. Advertisement In manufacturing, it helps operators and quality inspectors track defects, production issues, machine stoppages, and other recurring problems. Simple Factory Example Imagine a quality inspector checks 100 finished products and identifies these defects: Instead of… Read more: Check Sheet: A Simple Tool for Collecting Quality Data in Manufacturing
- KIE Factory Stories: Why Did the Production Manager Celebrate a Machine Breakdown?“Machine 7 has stopped again!” The supervisor rushed to inform the Production Manager. Advertisement But instead of getting angry, the manager smiled. The supervisor was confused. “Sir, we are losing production. Why are you smiling?” The manager asked him to check the breakdown history. Listen 0:00 / —:— Machine 7 had stopped 14 times in… Read more: KIE Factory Stories: Why Did the Production Manager Celebrate a Machine Breakdown?
- Inventory Turnover Ratio: Measure How Efficiently a Factory Uses Its InventoryWhat is Inventory Turnover Ratio? Inventory Turnover Ratio measures how many times a company sells or uses its inventory during a specific period. Advertisement It helps manufacturers understand whether materials and finished goods are moving efficiently or remaining in stock for too long. Formula Inventory Turnover Ratio = Cost of Goods Sold (COGS) ÷ Average… Read more: Inventory Turnover Ratio: Measure How Efficiently a Factory Uses Its Inventory
- KIE Factory Stories: Why Did the Plant Head Ask Everyone to Stop Using the Forklift?“Who authorized this decision? We have materials to move!” The Warehouse Manager was furious. Advertisement The Plant Head had temporarily stopped forklift movement in one section of the factory. There had been no accident. No equipment failure. No major safety complaint. Listen 0:00 / —:— But during a factory walk, the Plant Head had noticed… Read more: KIE Factory Stories: Why Did the Plant Head Ask Everyone to Stop Using the Forklift?
- ABC Analysis: How to Prioritize Inventory in a FactoryWhat is ABC Analysis? ABC Analysis is an inventory management technique that classifies materials based on their annual consumption value. Advertisement It helps factories identify which materials need more attention and tighter control. The Three Categories A – High-value items B – Medium-value items Listen 0:00 / —:— C – Low-value items Simple Example A… Read more: ABC Analysis: How to Prioritize Inventory in a Factory
- KIE Factory Stories: Why Did the Operator Refuse to Use the New Automated System?“The new system is ready. Why are you still maintaining the old records?” The Production Manager was frustrated. Advertisement The factory had invested in a digital production monitoring system. Machine data was collected automatically. Production reports were generated in seconds. But one experienced operator continued maintaining his handwritten production notebook. Listen 0:00 / —:— The… Read more: KIE Factory Stories: Why Did the Operator Refuse to Use the New Automated System?
- What is Economic Order Quantity (EOQ) and How Does It Reduce Inventory Costs?What is Economic Order Quantity? Economic Order Quantity (EOQ) is an inventory management method used to calculate the most economical quantity of material to order at one time. Advertisement It balances two important costs: In simple terms Ordering materials in very small quantities means placing purchase orders frequently. Ordering in very large quantities means keeping… Read more: What is Economic Order Quantity (EOQ) and How Does It Reduce Inventory Costs?
- KIE Factory Stories: Why Did the Factory Reject an Order It Had Already Won?The Sales Manager walked into the Plant Head’s office with exciting news. “We have received an order for 5,000 additional units. The customer wants delivery within two weeks.” Advertisement The Production Manager immediately started calculating machine capacity. “We can manage it with overtime.” The Sales Manager smiled. But the Plant Head asked one question. Listen… Read more: KIE Factory Stories: Why Did the Factory Reject an Order It Had Already Won?
- What is a Master Production Schedule (MPS) and Why Is It Important?What is a Master Production Schedule? A Master Production Schedule (MPS) is a detailed plan that specifies which finished products must be manufactured, in what quantities, and during which time periods. Advertisement It converts customer demand and business requirements into a planned production schedule. In simple terms Imagine an electronics factory receives orders for three… Read more: What is a Master Production Schedule (MPS) and Why Is It Important?
Now or Never
We’ve got your back on your manufacturing journey — Stay in touch
Follow us for step-by-step guidance, templates, and insights that save time and reduce mistakes.
Know Industrial Engineering Platform – Helping manufacturing industry professionals worldwide since 2019
Discover more from Know Industrial Engineering
Subscribe to get the latest posts sent to your email.


Informative Article..
Thanks for showings steps and template
Gives good insight for Pareto analysis and simply explains the basic elements.
Very informative article..
Very informative article.
Amazing stuff… good information!
This is a great article. Very informative and well-written.