Waterfall Chart Excel Template. All you need to do is to enter your data into the table and the excel waterfall chart will automatically reflect the changes. Select b4 in the chart and enter this formula.
Use the fill tool to drag the formula down to the end of the column again. Select b4 in the chart and enter this formula. Now your excel waterfall chart should look like this.
Right click on the waterfall chart and go to select data.
Waterfall charts excel can vary slightly. The easiest way to assemble a waterfall chart in excel is to use a premade template. You can also use the all charts tab in recommended charts to create a waterfall chart. Right click on the waterfall chart and go to select data.