Advanced Waterfall Chart

The Waterfall Chart is most frequently used to display the effect of the series of consecutive positive or negative events on the initial value.

waterfall 1.png

The columns can be colored either by conditional formatting as above, or by category.

Also, the columns can be stacked by another dimension to see each income or expense in higher detail:

waterfall 2.png