Waterfall Chart Example. Your chart should now look like this. For instance you can create a waterfall chart for a profit and loss statement.
Now your excel waterfall chart should look like this. Next select d4 in the up column and enter this. Select b4 in the chart and enter this formula.
Your chart should now look like this.
Next select d4 in the up column and enter this. Now for example you want to visualize the data on a waterfall chart. A waterfall chart shows a running total as values are added or subtracted. Let s say that you peg the first value at 1 000 and the second value at 2 000.