Excel Waterfall Chart
Waterfall chart is a good option for visualizing related positive and negative developments. With this chart, you can easily see how final result is achieved. Here is how to make an easy Excel waterfall chart.
Waterfall chart is basically a stacked column chart. Some data series are set to be invisible, so instead of staying on top of each other, boxes looks like they are afloat. Therefore making basic excel waterfall chart is very easy. But when you want to make it look good, than starts hard work.
Here is basic part:
Since it is a stacked column chart, all you need to do is to arrange your data before charting it. Than set certain columns as invisible.
This is our base data:
And this is our arranged data which we are going to use as chart source data. This setup will ensure our significant boxes to be placed on correct coordinates on the chart area.
Chart data in detail (These formulas provides interactivity. As base values changes, boxes will adjust accordingly.):
Select this data as a whole and insert a stacked column chart. I should look like this:
Remove legend, set series fill color and border color for bottom boxes of middle 3 series to no fill, set fill and border color for series 1-2-5 as green and 3-4 as red. Here is your very basic excel waterfall chart:
If you want to enhance it to have a real nice looking chart, continue to next page.