Pareto Chart  Diagram  Pareto Principles  Excel Template

What is Pareto Chart in 7 QC Tools?

→ It was invented by Mr. Vilfredo_Pareto and it is a combination of a bar graph and a line graph. It helps us to prioritize.
→ In this diagram the order of the largest number of occurrences by item or by classes and the cumulative sum total are available.
→ The bar graph shows the number of defects in descending order and the line graph shows the cumulative percentage of the defect.
→ It is the most popular prioritization tool out of 7 QC Tools for Process Improvement.
Join Industrial Knowledge WhatsApp Group for Daily Updates

What is the Pareto Chart used for?

  • This tool is used for Prioritization
  • It is used to calculate the potential impact of things
  • It is used for identifying the vital few and the trivial many.

7 QC Tools Presentation Bundle


→ Vilfredo Pareto was an Italian engineer, sociologist, economist, political scientist, and philosopher.
→ He shows an observation that is: "80% of the land in Italy was owned by about 20% of the population."
→ He introduced the concept of efficiency and helped to develop the field of microeconomics.
→ The Pareto principle was named after him.
→ He also contributed to the fields of sociology and mathematics.

What is the Pareto Principle?

→ It is also known as the 80/20 rule, the law of the vital few or the principle of factor sparsity
→ 80% of the Problems come from 20% of the causes.
→ 80% of the Output comes from 20% of the Input.
→ It Distinguishes between Vital Few from Trivial Many.
→ 80% of the Results come from 20% of the effort

Pareto Principle

How to Do Pareto Chart Analysis?

→ As mentioned in the above picture we can analyze the chart based on the 80/20 rules such as the 20% causes that are responsible for 80% of the problems. Similarly, by applying the 20% effort we can get rid of 80% of the problems.

How do I make a Pareto chart?

➝ Refer to the five steps for Making a Pareto_Chart:
  1. Select the problem.
  2. Collection of data.
  3. Sort data & calculate the cumulative percentage.
  4. Draw the axes, bars, cumulative percentage line, and labeling.
  5. Identify Priority and plan further action.

Step 1. Select the Problem:

➝ Select the problem for investigation.
➝ Determine the data collection method and period of collection.
➝ Design a separate Check Sheet if necessary.
➝ E.g.: Defect analysis.

Step 2. Collection of data:

➝ The second step is data collection for the graph after the selection of the problem

Step 3. Sort data & calculate the cumulative percentage:

➝ The third step is to sort out data and find the cumulative percentage.
➝ Refer the below picture for better understanding and clarification

Step 2 and 3

Step 4. Draw the axes, bars, cumulative percentage line, and labeling:

➝ Now, we have to draw the axes, bars, and cumulative percentage line and give title and labeling to the_chart
➝ See the below picture in which all the above things are mentioned.

Construction of  Pareto_Chart

Step 5: Identify Priority and plan further action:

→ Now we analyze the chart and identify Vital Few problems from the Trivial Many by using the 80:20 principle and plan further action:
→ Let's say in our example we are taking defects D, E, F, and defect A for further action because the contribution of these defects is almost around 81%. it is as per the 80:20 Rule.
→ It is not mandatory to take defects up to 80% we can take only the first two defects which contribute around 65% problem.
→ Now we will take action on these defects by finding the root cause with the help of any root cause analysis method (i.e. Cause and Effect Diagram or 5 Why analysis) of defect generation and implement preventive action on it.

👉 Pareto Chart Excel Template Download


→ We can easily distinguish between Vital Few and Trivial Many.
→ It displays the relative importance of the causes of the problem.
→ It helps the team to focus on those causes that will have the greatest impact when solved.
→ By using 20% of resources we can solve 80% of problems.
→ We can easily understand the impact of the defect on our production
→ It is very easy to analyze by this tool and also this tool is very useful in the various project of six sigma, QCC, and 7QC Tools.

👉 See Also:


  1. Thanks for giving new information

  2. Nor only in six sigma. Long before six sigma there is Toyota Production System as well as QCC and 7QC Tools

  3. what is cumulative and why needed in pareto chart, can you explain me briefly sir..

    1. Cumulative is percentage and it is used for creating the graph of cumulative percentage so we can have an estimate abut it.

  4. Good morming, i had download pareto chart file. I would need to edit the file. Is possible to have the password??


    Regards, Carlo.

    1. Currently our team is working on that we will defiantly help you for that.

  5. Good day, I have been following your writeups for a while and I must commend that you are doing a fantastic job sir. Kudos!

  6. Nice post thank you Michael


Post a Comment

Previous Post Next Post