Waterfall Chart With Multiple Series. The default legend of the waterfall chart shows increasing decreasing and total columns. Hide the blank series and the chart is complete.
It requires a slightly different calculation for the 3 series because the balance series is the stepping stone for the visible portion of the bars and is actually hidden in the chart. Click on the base series to select them. You can have stacks columns consisting of multiple series in the waterfall chart.
Hide the blank series and the chart is complete.
A compound waterfall chart with up to two elements can be made using the up down bar approach. You can have stacks columns consisting of multiple series in the waterfall chart. The default legend of the waterfall chart shows increasing decreasing and total columns. A compound waterfall chart with up to two elements can be made using the up down bar approach.