Your presentation-development partner … demonstrate and inspire!

Data-Driven Chart 015

Waterfall Charts

Waterfall Charts example of possible use

Waterfall bar and column charts are simply a way to add and subtract values and show a total. They were first developed and used at McKinsey & Co., Inc.; but they are very widely used now. These types of charts are a variation on the subdivided bar charts and subdivided column charts. They need to be calculated, as the worksheet won't do the work for you.

Here's how they work. The worksheet is set up with the first column as a spacer column: the bars/columns have no fill or line. That means that they are invisible, but they provide a place on which to "stack" the next segment (the segment you want to be visible). The first bar/column, any subtotals that you need, and the ending bar/column all touch the baseline. All other segments "float" on top of the invisible spacer stack. Open the worksheet and see how the data is plotted. If you need more explanation, look at the tutorial for this series for an explanation of how to plot the data in the worksheet.

The space for labels below the horizontal baseline in the column waterfalls is sometime very small. You can move these labels up under the segment, so they float along with the segments. This is actually a good way to label these segments. Remember that you're always trying to make it easy on your audience and not force their eyes all over the slide to get the information they need. Keeping the labels next to the plotted objects is a good thing to do.

Key search words: waterfall, sum, arithmetic, addition, subtraction, totals, subtotals


Tutorial for Radar Charts

Keywords: waterfall, sum, arithmetic, addition, subtraction, totals, subtotals

Categories: Data-Driven Charts

Links to instructions for getting the framework into your presentation

Click on a name for more information.
Click on a thumbnail to view a larger image