Stacked Waterfall Chart Excel Template. The beauty of this method is that you don t have to jump through any hoops whatsoever. Select b4 in the chart and enter this formula.
Your chart should now look like this. Select the insert waterfall funnel stock surface or radar chart button. The beauty of this method is that you don t have to jump through any hoops whatsoever.
If e4 0 e4 0 use the fill tool to drag the formula down to the end of the column again.
Next select d4 in the up column and enter this. Your chart should now look like this. A waterfall chart or bridge chart can be a great way to visualize adjustments made to an initial value such as the breakdown of expenses in an income statement leading to a final net income value. To begin with create a default waterfall chart based on your actual data.
