Double Waterfall Chart
Two waterfall charts placed side by side to compare how two different totals are built up or broken down — making the variance between them immediately visible.
// 01 — The chart
What it looks like
A double waterfall chart showing two adjacent bridges — Q1 to Q2 and Q2 to Q3 — revealing the drivers of change across consecutive periods.
// 02 — Definition
What is a double waterfall chart?
A double waterfall chart places two waterfall breakdowns side by side so you can compare how two totals differ. Each side decomposes its total into the contributing increases and decreases, making it easy to see which components explain the difference.
This format is especially popular in financial analysis and management consulting. Analysts use it to bridge from one period to the next, or to compare budget vs. actual performance by showing the positive and negative drivers on each side.
The key insight is that both waterfalls share a common midpoint — typically the ending total of the first waterfall equals the starting total of the second. This creates a continuous narrative: “Here’s how we got to X, and here’s what happened next.”
Consulting staple: The double waterfall is a staple of McKinsey, BCG, and Bain presentations. It’s the go-to format for variance analysis, P&L bridges, and any story about “what changed and why.”
// 03 — Anatomy
Parts of a double waterfall chart
// 04 — Usage
When to use it — and when not to
- Comparing two consecutive periods (Q1→Q2 then Q2→Q3)
- Showing budget vs. actual with component-level variance
- Explaining a two-step transformation (revenue → gross profit → net profit)
- Management presentations that need a continuous narrative
- Variance analysis across paired breakdowns
- Any story structured as 'from here, then from there'
- The two totals don't share a logical connection — it becomes two unrelated charts
- You have more than 8-10 steps total — the chart gets too wide
- A simple waterfall already tells the whole story
- The audience needs exact values more than a visual narrative
- Changes across many time periods — use a line or area chart instead
- Components don't add up to the totals — the format assumes additive decomposition
// 05 — Reading guide
How to read a double waterfall chart
Follow these steps whenever you encounter a double waterfall chart in the wild.
Identify the two starting totals
Find the full-height bars on the left side of each waterfall. These anchor the narrative — one is the 'from' and one is the 'to'.
Read the first waterfall left to right
Each floating bar is a positive (green, going up) or negative (red, going down) step. They show how the first total transforms into the shared midpoint.
Find the shared midpoint
The ending bar of the first waterfall should equal the starting bar of the second. This is the pivot of the narrative.
Read the second waterfall
Continue left to right through the second set of steps. This shows how the midpoint transforms into the final total.
Compare the two stories
Look for differences: which waterfall has bigger steps? Different drivers? This comparison is the whole point of the double format.
// 06 — Pitfalls
Common mistakes
Mismatched midpoint
The ending total of waterfall 1 must equal the starting total of waterfall 2. If they don't match, add a reconciliation step.
Inconsistent step ordering
Use the same order for shared components in both waterfalls. If 'Price' appears first in waterfall 1, it should appear first in waterfall 2.
Too many steps
Combine small steps into an 'Other' category. A double waterfall with 15+ bars is unreadable.
No color coding for direction
Always use distinct colors for positive and negative steps. Green/red or blue/orange — just be consistent.
Missing connector lines
Dotted lines connecting the top of one bar to the base of the next are essential for readability. Without them, readers lose track of the running total.
// 07 — In the wild
Real-world examples
P&L bridge: H1 vs H2
CFOs present revenue drivers from the first half alongside cost drivers from the second half, showing how the full-year result was built in two stages.
Budget vs. actual vs. forecast
FP&A teams use a double waterfall to bridge from budget to actual on the left, then from actual to revised forecast on the right.
Market share decomposition
Consumer goods companies show how organic growth (pricing, volume) drove the first period, while M&A and divestitures drove the second.
// 08 — Quick reference
Key facts
Also known as
Twin bridge chart, paired waterfall
Data type
Additive decomposition of two linked totals
Best for
Variance analysis, P&L bridges, consecutive period comparison
Audience level
Intermediate — familiar to finance professionals
Step limit
4–6 steps per waterfall for readability
Related to
Waterfall chart, Sankey diagram, bar chart
// 09 — Variations
Variations and extensions
Stacked double waterfall
Each step bar is further subdivided into sub-components, adding a second level of detail.
Horizontal double waterfall
Bars run left to right with waterfalls stacked vertically. Useful for very long category labels.
Multi-bridge waterfall
Three or more waterfalls chained together, each sharing a midpoint with its neighbors.
// 10 — FAQs
Frequently asked questions
What is a double waterfall chart?+
A double waterfall chart places two waterfall breakdowns side by side so you can compare how two totals differ. Each side decomposes its total into the contributing increases and decreases, making it easy to see which components explain the difference.
When should you use a double waterfall chart?+
Use a double waterfall chart when comparing two consecutive periods (Q1→Q2 then Q2→Q3). It also works well when showing budget vs. actual with component-level variance, and when explaining a two-step transformation (revenue → gross profit → net profit).
When should you avoid a double waterfall chart?+
Avoid a double waterfall chart when the two totals don't share a logical connection — it becomes two unrelated charts. It is also a poor fit when you have more than 8-10 steps total — the chart gets too wide, or when a simple waterfall already tells the whole story.
What is another name for a double waterfall chart?+
Double Waterfall Chart is also known as Twin bridge chart, paired waterfall. The name varies between fields, but the visualisation technique is the same.
What size of dataset works best for a double waterfall chart?+
Double Waterfall Chart works best for Variance analysis, P&L bridges, consecutive period comparison. Outside that range the chart either looks empty or becomes too cluttered to read clearly.
Is a double waterfall chart suitable for dashboards?+
Yes — a double waterfall chart can work well in dashboards as long as the panel is large enough for readers to perceive the encoded values, has a clear title, and includes the legend or axis labels needed to interpret it.