Stacked Waterfall Chart Excel Template. Your chart should now look like this. 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. If so well done. Repeat the same steps for the line section.
Click insert insert waterfall or stock chart waterfall.
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. Select b4 in the chart and enter this formula. The connecting lines between the columns make the chart look like. If so well done.
