Your presentation-development partner … demonstrate and inspire!

DD015 – Data-Driven Charts 015 – Waterfall Charts


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: Tutorial for Data-Driven Charts 015 – Waterfall Charts

Frameworks available in this series

Click on a thumbnail to see a larger image of that framework.

DD015 – dd015_v01

Subscribe to Download


DD015 – dd015_v02

Subscribe to Download


DD015 – dd015_v03

Subscribe to Download


DD015 – dd015_v04

Subscribe to Download


Links to instructions for getting the framework into your presentation

  1. Determine the best file type for your needs
  2. Download the file
  3. Import the framework into your presentation
    1. Importing a PPT file
    2. Importing a EMF or PNG

Keywords: waterfall, sum, arithmetic, addition, subtraction, totals, subtotals, chart examples, powerpoint templates, powerpoint presentations, powerpoint graphics, chart templates, keynote presentation, keynote charts, presenter tools, powerpoint presentation ideas, presentation images, powerpoint charts

Top Share