BLOG – PRODUCTIVITY TOOLS AND MORE…

BLOG - PRODUCTIVITY TOOLS AND MORE...

Create a Pareto Chart in Excel in 2 steps – Easy Tutorial

Aug 22, 2020 | Microsoft Excel Tutorial

Pareto Chart In Excel – Overview

This tutorial teaches you how to create a Pareto Chart in Excel in 2 simple steps. A Pareto Chart or Pareto Diagram helps to turn your data into clear visualizable actionable insights. It highlights what really matters by putting emphasis on the most important drivers of a phenomenon.

A Pareto Chart illustrates the Pareto distribution that may exist with your data.  A Pareto Distribution is observed when the Pareto Principle holds. The Pareto Principle (or “20-80 rule” or “Law of the Vital Few”) states that, for many events, roughly 80% of the effects come from 20% of the causes. As an example, illustrations in this tutorial will show that 80% of the customer complaints ensue from only 20% of the products. For more details about the Pareto Principle, please refer to the FAQ by clicking here.

Pareto Chart In Excel – Example
Pareto Chart in Excel
Pareto Chart In Excel – VIDEO Tutorial with 2 Simple Steps
To create a Pareto Chart in Excel 2016, Excel 2019 or Excel 365, simply execute these 2 steps

STEP 1 – Select your data: 1 column for the “causes” and 1 column for their “impacts”.  There is no need for the data to be sorted.

Create an Excel Pareto Chart - Select Data - 1 column for "causes" + 1 column for "impacts"

 

STEP 2 – Select Pareto Chart in the ribbon: Insert > Insert Statistical Chart > Pareto. The Pareto Chart you get is then ready to be customized!

Insert - Statistical Chart - Pareto Chart
Pareto Chart in Excel - Default Excel Pareto Chart

That’s it! Congratulations!  

Additionally, you can customize your Excel Pareto Chart your own way. There are 2 ways to customize your Pareto Chart in Excel: chart design menu in the ribbon + right-click menus in the chart

1 – In the ribbon, several design options are available under the Chart Design menu:

Chart Design in the Excel ribbon

2 – In the Pareto Chart, the menus you get by right-clicking provide you as well with different design options:

Design options when right-clicking in the chart
To create a Pareto Chart in Excel 2013, simply follow the tutorial below

>> Pareto Chart  in Excel 2013 <<

To create a Pareto Chart in Excel 2010, simply follow the tutorial below

>> Pareto Chart  in Excel 2010 <<

Pareto chart in Excel – Free Templates

You can download the free template used as a Pareto Chart example in this tutorial:

  >> Download the Free Excel Pareto Chart Template <<

You can download the free template provided by Microsoft Office that combines a Pareto Analysis in a table with a Pareto Chart:

>> Download the Free Cost Analysis & Pareto Chart Template from Microsoft <<

Pareto Chart In Excel  – Pareto Analysis in An Excel SHEET or VIA A Pareto Chart? What is the best?

In some circumstances, the Pareto Chart may be scattered with too many pieces of information; it may not yield clear visualizable and actionable insights.  It happens when the data set is large and contains numerous items (“causes”) to analyze.

In such a case, we recommend you to crunch the data with a direct Pareto Analysis in an Excel sheet. A Pareto Analysis can be done manually like explained in this Pareto Analysis Excel tutorial in 5 simple steps.  To automate a Pareto Analysis in just one-click like shown in the DEMO section of this website,  you can use an Excel Pareto Analysis Add-In. An Excel Add-in is particularly useful for Excel users who have to do Pareto Analysis in Excel on a frequent basis. The Excel Pareto Analysis Add-In also helps to save time when the data-set to analyze is defined with active filters in Excel. These filters can stay in place when using the Add-in hence avoiding additional time-consuming steps of data preparation.

Pareto Chart In Excel – Conclusion

With Microsoft Excel 2016 and more recent versions, it takes only 2 steps to build a Pareto Chart. Since it is very fast and easy, we advise you to always have a look at the data you work with by making a Pareto Chart. You may find insightful results that could lead to a better time or budget management in your business operations.

“A good business strategy is an operational execution driven by a Pareto Analysis”

Hofstadter’s Law and the Planning Fallacy

Hofstadter’s Law falls into the Planning Fallacy category by stating “It always takes longer than you expect, even when you take into account Hofstadter’s Law”.

How to build a Pareto Chart in Google Sheets in 2 Easy Steps

This easy step-by-step tutorial shows how to build a Pareto Chart in Google Sheets. Download now the Free Google Sheets Pareto Chart template for immediate use.

Best Microsoft Excel Guide Books – Top 3 for Data Analysis

These 3 Best Microsoft Excel Guide Books provide Excel users with Powerful Data & Business Analysis techniques that go beyond Pareto Analysis and Pareto Charts.

Optimize Easily your Well-being with the 80/20 rule Approach

Happiness, the feeling of positivity, really is the foundation of productivity. - Miguel McKelvey Everyone deserves to have a happy and fulfilled life. Take control now of your well-being by applying the simple yet powerful 20/80 Rule to your life. This article shows...

How to do a Pareto Analysis in Excel in 5 simple steps – Easy tutorial

This tutorial explains how to do a manual Pareto Analysis in Excel in 5 simple steps. A Pareto Analysis is particularly useful to focus on what really matters as the Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes.

The Powerful 80/20 Principle: The Secret of Achieving More with Less

The Powerful 80/20 Principle: The Secret of Achieving More with Less. A new perspective on the Pareto Principle.

Create a Pareto Chart in Excel in 2 steps – Easy Tutorial

The tutorial shows how to create a Pareto Chart in Excel in 2 simple steps after explaining the basics of the Pareto Principle or 20 80 rule.

1 Easy and Smart Way of Getting Things Done

Getting things done is a prerequisite to productivity. Ray Dalio explains how to enhance productivity with the 20/80 Rule in his brilliant post. Achieving by doing less is even better. Some say it is an easily actionable insight for better productivity. Dropping the...

The Powerful 80/20 Rule | Pareto Law | Pareto Rule by Ray Dalio

The famous American hedge fund billionaire Ray Dalio made this brilliant post about the 20/80 Rule which is also sometimes called the Pareto Rule or the Pareto Law:The 80/20 Rule The 80 20 Rule states that you get 80 percent of the value out of something from 20...

Pareto Analysis Excel Add-In

Buying the Pareto Analysis Excel Add-In is a risk-free experience. If you are not happy with it, you simply get your money back. No questions asked.

Execute Better.  Execute Faster. Automate any Excel Pareto Analysis.

Pin It on Pinterest