How to Create a Waterfall Chart for Variance Analysis

Prepare the source for the waterfall chart explaining a start-to-finish bridge

Use a starting total, individual positive and negative drivers, and an ending total in logical order.

Build the visual

1. Prepare the opening value and each bridge item.
2. Calculate the closing value independently to verify the bridge.
3. Insert a Waterfall chart.
4. Mark the opening and closing bars as totals.
5. Check the sign of every driver.
6. Use labels for important amounts.
7. Add a title that states the period and measure.

Design rules

• Use one color for increases, one for decreases, and a neutral total color.
• Order drivers by business logic or impact.
• Keep labels readable.
• Avoid decorative 3D effects.
• Reconcile the final bar to the source result.

Common chart mistakes

Mistake	Why it matters
Entering a decrease as positive	The bridge moves in the wrong direction.
Failing to mark totals	The opening or closing bar floats like a change.
Using too many tiny drivers	The chart becomes unreadable.
Forcing the ending value instead of reconciling it	The bridge hides an underlying error.
Mixing units	Amounts and percentages cannot share one bridge.

Reconcile the bridge before presenting it

Use a simple control calculation outside the chart. If the starting value is 1,000 and the drivers are +120, -80, and +30, the ending value must be 1,070. Enter those values in the source, insert the Waterfall chart, and explicitly set the first and last bars as totals. If the visual ends anywhere else, the problem is in a sign, a source value, or a total setting.

For management reporting, group immaterial drivers when they distract from the story, but keep a supporting schedule that reconciles the grouped amount. A Waterfall chart should explain movement, not merely decorate it. Label the period and unit, state whether increases are favorable or unfavorable when that is not obvious, and avoid mixing percentages with currency or counts in the same bridge.

Use sign conventions consistently

For a variance bridge, decide whether favorable and unfavorable changes are entered as positive and negative amounts or whether the source values follow an accounting sign convention. Do not switch conventions halfway through the bridge. If Gross Profit rises by 40 from volume and falls by 25 from price, the chart should reconcile those exact signed drivers to the final result. A separate reconciliation formula beside the chart makes sign errors much easier to catch.

Frequently asked questions

What is the difference from a stacked column chart?

A Waterfall chart carries the running total across positive and negative changes.

Can I group small drivers?

Yes, combine immaterial items into Other while keeping supporting detail elsewhere.

Why does the final bar not match?

One or more signs, values, or total settings are incorrect.

Can I use it for profit analysis?

Yes, when the drivers clearly explain the move from one profit figure to another.