<\/p>\n
Pareto Charts<\/strong> are one of the many new Charts available only in Excel<\/a> 2016.<\/p>\n They are\u00a0very visual<\/strong> as it can easily show you the biggest factors in the data set<\/strong>, like seeing which issues are the most common<\/strong>.<\/p>\n A Pareto chart,<\/strong>\u00a0also called a\u00a0sorted histogram<\/strong>, is a column chart<\/a> which sorts the data in descending order. \u00a0The largest items are listed first for emphasis.<\/p>\n A Pareto chart\u00a0includes a secondary line chart, symbolizing the cumulative\u00a0percentage of the total.<\/strong><\/p>\n The Pareto Principle as explained in Wikipedia<\/a> and FinanceReference<\/a>, named for Italian economist Vilfredo Pareto<\/a>, 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\u2019s sales come from 20% of one\u2019s customers, or pretty much any 80-20 metaphor you can come up with.<\/p>\n To learn more about the Pareto Chart you can read this post here over at PeltirTech.com<\/a><\/p>\n <\/p>\n In the examplebelow I show you how easy it is to insert a Pareto\u00a0Chart using Excel 2016.<\/p>\n To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016<\/a><\/p>\n