How to Make a Waterfall Chart in PowerPoint (The Right Way)

The problem with PowerPoint's native waterfall chart

PowerPoint's native waterfall chart (available via Insert → Chart → Waterfall) has several frustrating limitations:

• Colors are limited and poorly controlled — changing individual bar colors requires navigating non-obvious menus
• The connector lines between bars are styled as "bridges" that look more like stacked bars than connectors
• Value labels are positioned inconsistently and don't follow consulting conventions
• The chart lives in a chart object, which means it's embedded and harder to layout alongside other elements
• When data changes, the chart updates but often requires manual reformatting

For a quick internal chart, this might be acceptable. For a client-facing slide or a board deck, it almost never produces an acceptable result without substantial manual cleanup.

Method 1: Stacked bar chart in PowerPoint

The traditional consulting workaround is to build a waterfall from a stacked bar chart in PowerPoint. The trick is to use an invisible "spacer" series that lifts each bar to the correct floating position, with a visible "value" series on top.

Here's how it works:

1. Set up a table with three columns: Label, Invisible Base (the cumulative total before this bar), and Bar Value (the actual change)
2. For start and end bars, the base is 0 and the value is the full total
3. For intermediate bars, the base is the running total and the value is the change
4. Insert a stacked column chart in PowerPoint using this data
5. Format the "base" series to have no fill and no border — it becomes invisible
6. Format the "value" series with your chosen colors
7. Add connector lines manually as separate shapes on top of the chart

The result looks right, but the process takes 30-45 minutes for a reasonably complex chart and is error-prone. A single data change can break the layout.

Method 2: Build it directly from shapes

Some consultants skip charts entirely and build waterfalls from raw PowerPoint shapes — rectangles and lines. This approach gives full control over every visual element and produces slides that are easier to fine-tune.

The process:

1. Calculate all bar positions and heights manually (or in Excel)
2. Draw rectangles for each bar, positioning them precisely using PowerPoint's Size & Position panel
3. Add dashed lines as connector shapes
4. Add text boxes for all labels, values, and axis ticks

This produces the cleanest output — every element is exactly where you want it, colors are trivial to control, and the result looks exactly like a McKinsey or BCG chart. But it takes even longer than the stacked bar method and is completely manual.

Method 3: Build in Excel, paste as picture

Excel's built-in waterfall chart (available since Excel 2016) is more functional than PowerPoint's. Many teams build the chart in Excel, format it carefully, then paste it into PowerPoint as an image.

The advantage: Excel charts update when data changes, which saves time on revisions. The disadvantage: pasting as an image means the bars aren't individually editable in PowerPoint. If you later need to tweak a single color or move a label, you have to go back to Excel and re-paste.

What consulting analysts actually do

In practice, most MBB analysts use a combination of the above methods depending on the deadline and the stakes. For a rough internal analysis, the stacked bar method is fast enough. For a final client deliverable, shapes built directly in PowerPoint are more common — the extra time investment is justified by the quality of the output.

At every major consulting firm, there are also proprietary slide templates and PowerPoint add-ins that automate parts of this process. These tools aren't available externally — they're one of the productivity advantages that help analysts produce high-quality slides quickly.

The faster alternative

Waterfall Maker takes the shape-based approach — every bar is a native PowerPoint rectangle, every connector is a native line, every label is real text — and automates all the position calculations. You enter your data, pick a theme, and download a .pptx file with a fully editable waterfall slide.

Because the output is native shapes and text (not an embedded chart or image), you can open it in PowerPoint and tweak any individual element. Move a label, change one bar's color, adjust the chart area size — it all works as expected.

Formatting checklist for any method

Whatever method you use, run through this before considering the chart done:

• Does the title state the insight, not just describe the chart?
• Are start/end/subtotal bars a different color from increase/decrease bars?
• Are connector lines dashed (not solid) and light gray?
• Are value labels on or directly above each bar?
• Do labels for intermediate bars include the sign (+/–)?
• Is there a source citation at the bottom?
• Is the font consistent with the rest of the deck?
• Is the chart area aligned to the slide grid with consistent margins?