Pareto chart

- Another new chart type in Excel 2016,…is called a Pareto chart.…Now you will hear it pronounced differently,…possibly a Pareto chart or even a Pareto chart.…Pareto chart allows us to attract…not only the content or the sales…that we're talking about here say in column B,…but also the cumulative percent.…Now we don't need to actually have these numbers,…in prior versions of Excel, if you wanted to create…this kind of a chart, you would have needed formulas…like we see in column C,…and what these formulas do,…and we'll them in the chart momentarily,…is as we're looking at our sales here…and let's say this is a company that has offices…in these states only.…

We could say, if we're looking at…California, Texas, and Florida,…our sales from those three states comprise…almost 74% of our total,…and if we throw in New York, that's 83%.…Just looking at those four.…So these are arranged in descending order.…Now, we don't have to do that anymore.…In fact, we could be looking at data like this,…this happens to be sorted alphabetically.…