Pareto Charts are one of the many new Charts available only in Excel 2016.

They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common.

A Pareto chart, also called a sorted histogram, is a column chart which sorts the data in descending order.  The largest items are listed first for emphasis.

A Pareto chart includes a secondary line chart, symbolizing the cumulative percentage of the total.

The Pareto Principle as explained in Wikipedia and FinanceReference, named for Italian economist Vilfredo Pareto, is based on the observation that most of the effects of an action come from a small amount of the causes. This is often called the 80-20 rule, implying that 80% of the failures come from 20% of the types of defect, or that 80% of one’s sales come from 20% of one’s customers, or pretty much any 80-20 metaphor you can come up with.

To learn more about the Pareto Chart you can read this post here over at PeltirTech.com

 

In the examplebelow I show you how easy it is to insert a Pareto Chart using Excel 2016.

To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Highlight your table and go to Insert > Recommended Charts

Pareto Chart 01

Pareto Chart 02

 

STEP 2: Select All Charts > Histogram > Pareto > OK

Pareto Chart 03

 

STEP 3: Now you have your Pareto Chart.

Pareto Chart 04

 

STEP 4: You can further customize the look and feel of your Pareto Chart, by going to Chart Tools > Design / Format

Pareto Chart 05

 

STEP 5: In our example, let us go to Chart Tools > Design and pick one of the alternate designs.

Pareto Chart 06

 

Now you have your beautiful looking Pareto chart and you can quickly point out to your management where the biggest contributors of your sales are on…

Pareto Chart 07

Pareto Chart

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar!The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...
Apply Custom Chart Styles Excel's default Charts are bland and ugly but you can certainly spice them up to your liking.Using the Shape Styles group in the ribbon menu you can customize your Excel chart the way you or your boss wants.There are several formatting options including Shape Styles, Shap...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.DOWNL...