Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

Pareto analysis is a method by which you find the 80% of the problem caused by 20% of the people, or which customers provide most the revenue, or whatever.

Pareto analysis states that 80% of a project’s results are due to 20% of the inputs, and 80% of problems can be traced to 20% of the causes.

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.