Waterfall Chart Template. Now your excel waterfall chart should look like this. Right click on the waterfall chart and select change chart type.
Select the data table step 2. Waterfall chart template description. Right click on the waterfall chart and go to select data.
This template contains two separate worksheets for creating either a horizontal or vertical waterfall chart.
Net sales gross margin operating income income before taxes and net income are all either total or subtotal values not additional values. Right click on the waterfall chart and go to select data. Define intermediate values by placing an x in the pillars column. Use the design and format tabs to customize the look of your chart.