Microsoft Excel 2016 – Use Waterfall Charts to make your point

A Waterfall chart—sometimes called a bridge chart—displays a running total as values are added or subtracted. It's useful for understanding how an initial value (for example, net income) is affected by a series of positive or negative values.

The columns are color-coded so you can quickly tell positive from negative numbers. The initial and the final value columns often start on the horizontal axis, while the intermediate values are floating columns.

How to add a Waterfall chart:

1.     On the ribbon, click Insert tab.

2.     From the menu, choose Insert Waterfall or Stock Chart, then select Waterfall (screen shot--ribbon).

3. Use the Design and Format tabs to customize the look of your chart (screen shot--chart).

4. If you don't see these tabs, click anywhere in the waterfall chart to see the Chart Tools to the ribbon.