How does Excel make waterfall diagrams?

How does Excel make waterfall diagrams?

First, look at the effect of the above diagram: The top half is shaded, and the lower part is transparent. Perhaps the idea is that such a chart should use a different series of data to achieve the hanging effect of the data series by setting the color of the different series.

How to make a waterfall diagram is as follows:

1. Prepare data

In column C, add a "placeholder" secondary column.

C2 cell Write 0,c3 cell write formula

=b$2-sum (B$3:B3)

Copy down.

2. Create a chart

Click any cell in the data range, insert Column chart, select Stacked Column

The effect of inserting a stacked column chart is as follows:

3. Clear unwanted items

Click the legend, press the DELETE key, click the grid line, press the DELETE key to remove, click the vertical axis, and then press the DELETE key to delete. The effect is as follows:

Right-click the horizontal axis, format axis major tick mark type select None

The effect is set as follows: