How to Create Waterfall Charts in Excel

Starting to Build the Waterfall Chart

Now we can get down to the task of building the chart itself… Select the data portions of the table (excluding the Running Total row), choose the Insert menu tab, click on Column in the Charts section, and select the Stacked Column under the 2D Column section:

Insert Stacked Column Chart

Your results should look less than appealing at first:

Chart Pre-Swap

The data fields are switched around, so choose Switch Row/Column from the Data section of the Chart Tools Design menu tab.

Switch Row-Column

It may not look like it, but trust me when I say this is an improvement:

Chart Post-Swap