Waterfall Chart Example. Now your excel waterfall chart should look like this. If so well done.
Your chart should now look like this. If so well done. Here part of the floating column is below the x axis and another part is above.
Select b4 in the chart and enter this formula.
Finally the last bar represents the final value after applying each of the cashflows in order. It s useful for understanding how an initial value for example net income is affected by a series of positive and negative values. Finally the last bar represents the final value after applying each of the cashflows in order. Now your excel waterfall chart should look like this.
