11 Ways to Completely Revamp Your Pareto Chart

The Pareto chart is a quality-improvement method based on the Pareto principle, which states that 80% of an outcome is determined by 20% of its inputs. The 80/20 rule was first observed concerning population and … Read More

The Pareto chart is a quality-improvement method based on the Pareto principle, which states that 80% of an outcome is determined by 20% of its inputs. The 80/20 rule was first observed concerning population and income by Wilfredo Pareto, an Italian engineer, and economist. Around the turn of the century, Pareto observed that only 20% of Italy and many other European countries owned 80% of the income.

This 80/20 rule turns out to apply to a wide range of systems:

In the transportation industry, 20% of the potential triggers could account for 80% of the delays.

In a market, 20% of the sales can come from 20% of the customers or 20% of the goods.

In a manufacturing phase, 20% of the issues could account for 80% of the downtime.

Furthermore, each bar’s length reflects the ‘cost’ of each cause, and the bars are arranged from longest to shortest to highlight the most important or primary causes visually.

Such examples from various industries including:

  • Company – 20% of workers do 80% of the job.
  • Software development: A program’s logic is carried out with just 20% of the classes or code.
  • Program Reliability: Errors are caused by 20% of bugs, which account for 80% of all the errors. Fixing 20% of the bugs with the highest frequency can resolve approximately 80% of customer problems.
  • Health: About 80% of injuries and deaths are caused by 20% of the potential hazards.
  • Criminality – 80% of crimes are committed by 20% of offenders.
  • Sales – 20% of consumers account for 80% of sales and income.

Again, the key argument is that 80% of problems and accidents occur due to 20% of the triggers and resources. Overall, the Pareto 80/20 rule is not an unchangeable physical statute. The Pareto power-law Distribution follows the concept based on repeated observations and has proven to be useful in almost every area of life and many natural phenomena.

When Can a Pareto Chart Analysis Be Used?

In light of the preceding examples, we can see that Pareto charts serve a similar purpose regardless of the field in which they are used. Optimization is a standard feature.

It makes no difference if you’re trying to improve code, a business method, workflows, reporting procedures, or something else. Pareto map analysis can be used as a rule of thumb when attempting to identify a trend that will have the greatest effect when using the most important resources and activities.

A Pareto Chart’s Components:

The following is a list of the Pareto Chart’s components:

  • x-axis: data types
  • y-axis: number of occurrences
  • cumulative percentage curve – display the cumulative percentage (on the y-axis) when traversing the categories from left to right
  • graded bars in descending order – the order in which the bars are placed associated with the frequency of the occurrence

Constructing a Pareto Map:

Let’s say you’re searching for instances of bottlenecks in your business operation.

Step 1:

Choose a category to use to categorize the bottlenecks.

Step 2:

Decide which measurement is best for measuring the grouped categories.

Step 3:

Create a detailed timeline for the Pareto map to cover a single work cycle, a sprint, a full day, a week, or a month. Let’s say it’s a week for the sake of this example.

Step 4:

After you’ve worked out the first three, you’ll need to record or arrange your data in a table that matches the steps.

If the data on the number of bottlenecks for any of these types of bottlenecks is not already available, the organization must collect it. Arrange the data that already exists according to and bottleneck category you defined in the first step if you have it.

Step 5:

After collecting or arranging all of the data, put it all in an Excel table.

To begin, add up all of the different occurrences to get the total number (bottlenecks). You can do this by hand or with the aid of Excel summation tools.

Step 6:

At this stage, you must add up all of the occurrences for each bottleneck group. This can be accomplished by creating a new, smaller table or covering the “weekdays of the week” columns.

Then, from the largest number of occurrences to the smallest, organize your results (descending order).

Step 7:

Now that you have these columns side by side, figure out what percentage of each bottleneck is cumulative. Drag the formula down to the last row to apply the same formula to the other bottleneck groups.

Step 8:

Pick the entire data set (without counting the total number of occurrences). After that, choose INSERT CHARTS 2D COLUMN CLUSTERED COLUMN from the drop-down menu. This will result in a standard two-dimensional map with two sets of data.


Step 9:

To complete the map, right-click on any of the chart’s bars and pick Change series chart format from the drop-down menu.

There will be a dialogue box appear. Select COMBO in the far left of the dialogue box from the ‘All Charts’ pane.

Make the following modifications to the drop-down windows that refer to your data sets here:

  1. Clustered Columns are used to keep track of the number of occurrences.
  2. Adjust the cumulative percentage to Line and check the Secondary Axis checkbox.

Step 10:

Your Pareto map will be ready after you click OK. To make the chart easier to read, give it a title and change the secondary axis’ value to a percentage.


A Pareto chart is one of the effective methods in total quality control and six sigma methodologies. It’s essentially a bar graph that shows how much each cause influences an outcome or effect. These Diagrams (also known as the 80/20 Pareto rule) are extremely helpful for managers in finding and solving problems in the workflow process. You can easily find out the top 20% of your company’s processes are causing 80% of the problems. By resolving the big concerns, you will ensure that the company’s overall processes run more efficiently while fixing possible or real bottlenecks.

Author: admin