Stacked Waterfall Chart Excel Template. Click insert insert waterfall or stock chart waterfall. Next select d4 in the up column and enter 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. Repeat the same steps for the line section. In order to make your stacked column chart look like a waterfall chart you will need to make the base series invisible on the chart.
Use the design and format tabs to customize the look of your chart.
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. Next select d4 in the up column and enter this. Select b4 in the chart and enter this formula. Highlight all the data a1 b13.
