Waterfall Chart Template. If you don t see these tabs click anywhere in the waterfall chart to add the chart tools to the ribbon. Select b4 in the chart and enter this formula.
Select b4 in the chart and enter this formula. Add a new series using cell i4 as the series name i5 to i11 as the series values and c5 to c11 as the horizontal axis labels. Waterfall chart template description.
Define intermediate values by placing an x in the pillars column.
Go to insert waterfall icon waterfall chart. Click insert insert waterfall or stock chart waterfall. This waterfall chart template guides you step by step to construct a waterfall chart using raw data. If you want to use this.