How to Make a Waterfall Chart: The Step-by-Step Guide

Learn what waterfall charts show, when to use them for revenue bridges and budget variance, and how to format them so the story is immediately clear.

How to Make a Waterfall Chart: The Step-by-Step Guide

What a Waterfall Chart Actually Shows

A waterfall chart shows how a starting value is affected by a series of positive and negative changes to arrive at a final value. Each bar "floats" — its bottom edge starts where the previous bar ended. The result looks like a staircase, which is why finance teams call it a "bridge chart."

The power is that it answers "what changed and by how much?" in a single visual. A bar chart shows Q1 was $4M and Q4 was $5.2M. A waterfall shows new customers added $1.8M, upsells added $600K, but churn subtracted $1.2M — the breakdown is the story.

When to Use a Waterfall Chart

Revenue bridges are the classic use case. Start with last period's revenue, add sources, subtract losses, land at this period's total. Every SaaS board deck should have one.

Budget variance analysis works great too. Start with planned budget, show each line item's over/under-spend. Finance teams love this because it turns a dense spreadsheet into a scannable visual.

Profit and loss breakdowns: start with gross revenue, subtract costs by category, land at net income. For simpler comparisons, a bar chart is better — see how to make bar chart.

How to Read a Waterfall Chart

First and last bars are "totals" — they sit on the baseline and represent absolute values. Usually a different color (gray or dark blue) to distinguish from incremental bars.

Middle bars are changes. Positive extends upward, negative extends downward. Color coding is critical: green for positive, red for negative. This is the reader's primary guide.

The running total is implied by the top edge of each bar. Connector lines between bars make this explicit — optional but helpful.

Formatting Tips

Use exactly three colors: total bars (neutral), positive (green/blue), negative (red/orange). Every other color is noise.

Label each bar with its value including +/- signs. "+$1.8M" and "−$1.2M" are clearer than bare numbers because they reinforce direction.

Sort middle bars by magnitude. Largest positive first, largest negative last. Five to ten intermediate bars is the sweet spot. See how to present data for more on data clarity.

Common Mistakes

Missing total bars — without start/end anchors the chart has no reference. Always include both.

Inconsistent direction — positive always goes up, negative always goes down. No exceptions.

Using a waterfall for data that doesn't sum. If values are independent metrics, use a bar chart instead.

Real-World Example: SaaS Revenue Bridge

Starting ARR: $8.4M. New customers: +$2.1M. Expansion: +$890K. Reactivations: +$210K. Downgrades: −$430K. Churn: −$1.6M. Ending ARR: $9.57M. Seven bars, one clear story.

The chart instantly answers board questions. Where is growth from? New customers. How bad is churn? $1.6M (19% of starting ARR). All visible in a five-second scan.

Build Your Waterfall Chart

Open the waterfall chart maker, enter your starting value and incremental changes. The tool generates color-coded bars with connector lines and value labels automatically.

For waterfall charts in a larger report, use the full editor. Combine with stat cards for headline metrics and text blocks for narrative context.

Create Your Own Infographic

Put these ideas into practice with our free drag-and-drop editor. No signup required.

Open the Editor

Related Articles