To create a Waterfall Chart in Excel, you first need to have a dataset that includes a starting value, a series of positive and negative changes, and an ending value.

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.

To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.

If you instead make a chart from multiple rows and multiple columns, Excel will make one dimension the x-axis and make the other into different series.