Waterfall Chart With Multiple Series. Right click and choose format data series from the list. 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.
Waterfall Chart Analysis With Waterfall Bar Chart Storytelling With Data Chart Data Visualization Visualisation from www.pinterest.com
The waterfall bar chart shown below solves these problems. In order to make your stacked column chart look like a waterfall chart you will need to make the base series invisible on the chart. Hide the blank series and the chart is complete.
Hide the blank series and the chart is complete.
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. 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.
