Stacked Waterfall Chart Excel Template. If so well done. Convert the stacked chart into a waterfall chart click the base series right click then select format data series click fill in the menu and no fill in the drop down menu for colors.
The connecting lines between the columns make the chart look like. Repeat the same steps for the line section. Now your excel waterfall chart should look like this.
Convert the stacked chart into a waterfall chart click the base series right click then select format data series click fill in the menu and no fill in the drop down menu for colors.
The connecting lines between the columns make the chart look like. The initial and final values are shown as columns with the individual negative and positive adjustments depicted as floating steps. Next select d4 in the up column and enter 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.
