Waterfall graphs look like tiny staircases for numbers. They show how one value grows or shrinks, step by step, until it reaches a final number. They are great when you want to answer one simple question: “What changed, and why?”
TLDR: A waterfall graph shows how positive and negative changes move a starting number to an ending number. For example, a store may start with $50,000 in revenue, add $12,000 from online sales, lose $4,000 to refunds, and end at $58,000. It is useful for finance, sales, marketing, and project reports. If you need to explain numbers fast, a waterfall graph is your friendly little math staircase.
What Is a Waterfall Graph?
A waterfall graph, also called a waterfall chart, is a chart that shows a running total. It starts with one number. Then it adds or subtracts values. At the end, it shows the final number.
Think of it like checking your wallet.
- You start with $100.
- You earn $40.
- You buy pizza for $15.
- You pay for a movie ticket for $12.
- You end with $113.
A waterfall graph turns that story into bars. Some bars go up. Some bars go down. The final bar shows where you landed.
The name “waterfall” sounds dramatic. But do not worry. No swimming is required. The bars often look like they are flowing from left to right, like water moving down steps.
Why Waterfall Graphs Are Useful
Waterfall graphs are useful because they make change easy to see. A simple total does not tell the full story. A waterfall graph shows the journey.
Let’s say your company made $120,000 last month. This month it made $135,000. Nice. But why did revenue grow?
A waterfall graph can show this:
- Starting revenue: $120,000
- New customers: +$20,000
- Lost customers: -$8,000
- Price increase: +$5,000
- Discounts: -$2,000
- Ending revenue: $135,000
Now the story is clear. Growth came mostly from new customers. Losses came from churn and discounts. The graph makes it easy to explain in a meeting without making everyone stare at a giant spreadsheet.
How to Read a Waterfall Graph
Reading a waterfall graph is simple. Just follow the bars from left to right.
- Start with the first bar. This is your starting value.
- Look at each middle bar. These show increases or decreases.
- Check the colors. Green often means positive. Red often means negative.
- Watch the floating bars. They do not always begin at zero. They begin where the last value ended.
- End with the last bar. This is the final value.
The middle bars are the fun part. They show what pushed the number up or pulled it down. Each bar is like a little character in the story. One says, “I added profit!” Another says, “Oops, refunds happened.”
Here is a tiny example:
- Start: 1,000 website visitors
- Social media: +300 visitors
- Email campaign: +150 visitors
- Ad budget cut: -100 visitors
- Search traffic drop: -50 visitors
- End: 1,300 visitors
Without a waterfall graph, you might only see that traffic increased by 300 visitors. With the graph, you see what caused the increase.
Common Parts of a Waterfall Graph
Most waterfall graphs have a few basic parts.
- Starting bar: The first value in the story.
- Increase bars: Values that add to the total.
- Decrease bars: Values that subtract from the total.
- Connector lines: Thin lines that link bars together.
- Ending bar: The final result.
Some charts also include subtotals. These are mini-final bars inside the graph. For example, a profit chart may show gross profit before showing final net profit.
When Should You Use a Waterfall Graph?
Use a waterfall graph when you want to explain movement between two numbers. It works best when your audience needs to see causes, not just totals.
Great use cases include:
- Profit and loss reports
- Monthly revenue changes
- Budget increases and cuts
- Customer growth and churn
- Website traffic changes
- Project cost breakdowns
- Inventory changes
Do not use one for everything. If you only need to compare items, use a bar chart. If you need to show trends over time, use a line chart. If you need to show parts of a whole, use a pie chart, but only if you must. Pie charts get messy fast. Waterfall graphs shine when the question is: “How did we get from here to there?”
Waterfall Graph Examples
Example 1: Profit Breakdown
A small bakery starts the month with $30,000 in sales. It adds $8,000 from catering. It earns $4,000 from weekend events. Then it loses $6,000 to ingredient costs and $3,000 to staff overtime. The ending profit is $33,000.
This waterfall graph would make the bakery owner smile, then maybe glare at the butter supplier.
Example 2: Marketing Campaign Results
A company starts with 10,000 leads. A webinar adds 2,500. Paid ads add 1,800. Bad email deliverability removes 700. Unqualified leads remove 1,100. The final count is 12,500 leads.
This shows that the campaign worked. It also shows where leads leaked out.
Example 3: Personal Budget
You start the month with $2,000. Your paycheck adds $3,000. Rent removes $1,200. Food removes $500. Fun removes $300. Savings adds $700 to your future self. Your ending balance is $3,000.
That chart might say, “Nice job.” Or it might say, “Maybe fewer fancy coffees.”
Best Tools for Creating Waterfall Graphs
You do not need to be a data wizard. Many tools can create waterfall graphs quickly.
- Microsoft Excel: A classic choice. Excel has built-in waterfall charts. It is great for finance teams and spreadsheet fans.
- Google Sheets: Free and simple. You can create waterfall charts and share them with your team online.
- Tableau: Best for big dashboards. It is powerful and polished, but it has a learning curve.
- Power BI: Great for business reporting. It connects well with company data sources.
- Looker Studio: Useful for marketing and website analytics dashboards. It is handy for live reports.
- Canva: Good for simple visual reports and presentations. It is more design-friendly than data-heavy.
- Plotly: Great for developers. It works well with Python, R, and JavaScript.
If you are making a quick report, use Excel or Google Sheets. If you need a live business dashboard, try Power BI, Tableau, or Looker Studio. If you code, Plotly gives you lots of control.
Tips for Making a Great Waterfall Graph
A good waterfall graph should feel easy. Not like a math escape room.
- Use clear labels. People should know what each bar means.
- Use simple colors. One color for gains. One color for losses.
- Do not add too many bars. Keep it focused.
- Show the final value clearly. That is the big reveal.
- Add context. A title like “Revenue Change in Q2” helps a lot.
- Avoid tiny text. If people squint, the chart loses.
Final Thoughts
Waterfall graphs are simple, useful, and surprisingly satisfying. They turn number changes into a clear story. They show what helped, what hurt, and where you ended up.
Use them for revenue, profit, budgets, traffic, leads, or costs. Keep the design clean. Keep the labels short. Let the bars do the talking.
In the end, a waterfall graph is not just a chart. It is a detective story for your data. And the final bar is where the mystery gets solved.