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


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



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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can!To create an Excel Table you need to highlight your data and press CTRL+TSee Tutorial HereOnce you have your Excel Table you can add your Excel Sparklines inside one Column and us...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in ExcelYou can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...
Bubble Chart: 3 Variables On A Chart A Bubble Chart is an extension of the XY Scatter Chart.  It adds a 3rd variable to each point in the XY Scatter Chart.For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of...
Clustered Bar Chart: Year over Year Comparison If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014.DO...