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.

A waterfall chart is a plot of revenue on the X-axis and profit margin (i.e., profit as percent of revenue) on the Y-axis, rank-ordered from highest- to lowest-profit product, geography or customer.

Previous supply chain studies were neatly summarized in simple waterfall charts. But the averages that were cited hide important details that show the true extent of hidden arbitrage, waste and ...

But one that oversimplifies everything into a waterfall chart is also not useful; it will be misleading and will cause a false sense of security, at the very moment that extra vigilance is needed.