Waterfall Chart Explained: Visualize Revenue, Expenses & Profit Step by Step

When you need to show how an initial value is affected by a series of positive and negative changes to arrive at a final value, the waterfall chart is your best friend. Also called a bridge chart or cascade chart, it is a staple in financial reporting, budget analysis, and operational reviews. This guide explains how waterfall charts work, when to use them, and how to build one for free with ChartLoad.

What Is a Waterfall Chart?

A waterfall chart uses floating bars to show how sequential positive or negative values contribute to a cumulative total. The first bar starts at the baseline and represents the initial value (e.g., opening revenue). Subsequent bars float above or below the running total — green bars typically show increases, red bars show decreases, and a final bar shows the net result. You can create a free waterfall chart with ChartLoad in seconds.

How to Read a Waterfall Chart

Reading a waterfall chart is straightforward once you understand the structure:

1. Starting value: The first column anchors at zero and rises to the initial amount.
2. Intermediate bars: Each bar floats from where the previous bar ended. An increase extends upward; a decrease extends downward.
3. Subtotals: Some waterfall charts include subtotal columns that reset to the baseline, making it easier to see cumulative progress at key checkpoints.
4. Final value: The last column returns to the baseline and shows the net result after all changes.

Common Waterfall Chart Use Cases

1. Revenue to Profit Bridge

The most classic use case. Start with gross revenue, subtract cost of goods sold, operating expenses, taxes, and arrive at net profit. Every CFO and financial analyst has seen this chart in quarterly reviews.

2. Budget Variance Analysis

Start with the planned budget, add favorable variances (under-spending, extra revenue), subtract unfavorable variances (overruns, shortfalls), and show the actual result. This instantly reveals which departments stayed on track and which did not.

3. Inventory Changes

Begin with opening inventory, add purchases and returns, subtract sales and write-offs, and arrive at closing inventory. Warehouse managers use this to spot shrinkage or overstock patterns.

4. Population or Headcount Changes

Start with the beginning headcount, add new hires and transfers in, subtract terminations and transfers out, and show ending headcount. HR teams use this in workforce planning.

Waterfall Chart vs. Other Financial Charts

Several chart types overlap with waterfall charts. Here is how they compare:

The stacked bar chart can show composition but struggles with negative values. A standard bar chart compares categories but does not convey the running total. The Pareto chart ranks contributions and shows cumulative impact but only works with positive values. For a deeper dive into bar-based visuals, see our bar chart guide.

Step-by-Step: Build a Waterfall Chart with ChartLoad

1. Open the ChartLoad Waterfall Chart Maker.
2. Enter your starting value as the first data point (e.g., "Gross Revenue: 500000").
3. Add each intermediate change with a label and value. Use positive numbers for increases and negative numbers for decreases.
4. Mark your final total so the chart renders it as a baseline-anchored column.
5. Customize colors — green for gains, red for losses, and blue or gray for totals is the standard convention.
6. Add a descriptive title like "Q1 2026 Revenue-to-Profit Bridge."
7. Export or share your chart.

Waterfall Chart Best Practices

• Order matters. Arrange items in the logical sequence of your analysis (revenue first, then costs, then profit). Do not sort by size.
• Use color consistently. Green for positive, red for negative, and a neutral color for totals is universally understood.
• Label every bar. Show the absolute value on each bar so readers do not have to estimate from the axis.
• Add connector lines. Thin lines connecting bar endpoints guide the eye and make the running total clear.
• Limit to 10–15 bars. Too many steps overwhelm the chart. Group minor items into an "Other" category.
• Include subtotals. For long waterfalls, insert subtotal columns at logical breakpoints (e.g., after revenue items and after expense items).

Example: Revenue to Net Profit

Imagine a company reports the following for Q1:

• Gross Revenue: $500,000
• Returns & Refunds: −$25,000
• Net Revenue subtotal: $475,000
• Cost of Goods Sold: −$190,000
• Gross Profit subtotal: $285,000
• Operating Expenses: −$150,000
• Other Income: +$10,000
• Taxes: −$36,000
• Net Profit: $109,000

A waterfall chart turns these line items into a compelling visual story. Stakeholders instantly see that COGS and operating expenses are the largest drains, and they can spot where to focus cost-cutting efforts.

"A waterfall chart does not just show the numbers — it shows the narrative. Each bar tells a chapter of the financial story."

Complementary Charts

Pair your waterfall chart with other visualizations for a complete picture:

• A line chart to show how net profit trends over multiple quarters.
• A pie chart or donut chart to break down expense categories as proportions.
• A combo chart to overlay revenue and profit margin on a single view.
• A heatmap to compare waterfall metrics across regions or product lines.

Create Your Waterfall Chart for Free

Ready to visualize your financial data? Open ChartLoad's free waterfall chart maker, enter your values, and generate a professional bridge chart in under a minute. Explore 100+ chart types on ChartLoad.com — all free, no sign-up required.

---

Worked Example: SaaS MRR Bridge

A B2B SaaS team needs to explain to investors why monthly recurring revenue (MRR) barely moved last quarter despite signing big new logos. They build a waterfall starting from opening MRR and walk through new business, expansion, contraction, and churn to land on closing MRR.

Sample data: Opening MRR: $120,000; New Business: +$28,000; Expansion (upsells): +$14,000; Contraction (downgrades): -$9,000; Churn: -$22,000; Closing MRR: $131,000

The chart makes it obvious that strong new and expansion revenue ($42K combined) was almost entirely cancelled out by $31K of contraction and churn, so net growth was only $11K. The bars expose a retention problem that the headline 'MRR grew' number completely hides.

Frequently Asked Questions

How do I make a waterfall chart in Excel or Google Sheets?

Excel 2016+ has a built-in Waterfall option under Insert > Charts, but it offers limited control over subtotals and connectors. Google Sheets has no native waterfall type, so people fake it with a stacked bar chart and an invisible 'base' series. ChartLoad renders true waterfalls (with totals and connectors) without that workaround.

What is the difference between a waterfall chart and a bridge chart?

There is no difference. 'Waterfall chart,' 'bridge chart,' and 'cascade chart' are three names for the same visual. Finance teams tend to say 'bridge' (as in a revenue or MRR bridge), while analysts and BI tools more often call it a waterfall.

Can a waterfall chart go below zero?

Yes. If cumulative decreases push the running total below the baseline, the bars simply continue downward into negative territory, which is normal for cash-flow or loss bridges. Keep a visible zero gridline so readers can instantly see when the running total crosses from positive to negative.