What are Waterfall charts in Excel?

A waterfall chart shows 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 and negative values. The columns are color coded so you can quickly tell positive from negative numbers.

Select your data. Click Insert > Insert Waterfall or Stock chart > Waterfall. You can also use the All Charts tab in Recommended Charts to create a waterfall chart.