If you're working in excel 2013 or earlier versions, please follow the instructions below as a workaround to build your own chart using the stacked column chart feature
16+ How To Make A Waterfall Chart In Excel
Background. Use the design and format tabs to customize the look of your chart. A waterfall chart for this data will look like—
Waterfall Chart In Excel Easiest Method To Build from www.xelplus.com
How to create waterfall chart in excel. It requires a few extra steps for preparing your data before plotting. To create a waterfall chart, firstly, you need to arrange and type your data as below screenshot:
Stay in this view and change the chart type of before and after series to a line.
Layout of data in excel the first step is to reorganize the data and introduce new columns as shown in the figure that follows. If you're working in excel 2013 or earlier versions, please follow the instructions below as a workaround to build your own chart using the stacked column chart feature Click any column to select all columns in the chart. Excel won't automatically know which columns should be totals.
