Excel Waterfall Chart: How to Create and Use One

Excel has many charts, but the waterfall chart is one of the most useful. It shows how a number goes up and down step by step. Think of it like a money story. You start with one value, add some wins, subtract some costs, and land at the final result.

What Is an Excel Waterfall Chart?

A waterfall chart is a chart that shows changes between a starting number and an ending number.

It uses floating bars. Some bars go up. Some bars go down. The first and last bars usually touch the bottom line. These are called totals.

It is called a waterfall chart because the bars look like steps. They rise and fall like water moving over rocks. Fancy name. Simple idea.

You may also hear it called a:

• Bridge chart
• Cascade chart
• Flying bricks chart
• Profit and loss chart

That last nickname is not official. But it makes sense. Waterfall charts are very popular in finance.

When Should You Use a Waterfall Chart?

Use a waterfall chart when you want to explain why a number changed.

A normal column chart is good for comparing items. A line chart is good for trends. But a waterfall chart is best for showing a journey.

Here are common uses:

• Tracking monthly profit
• Explaining budget changes
• Showing revenue growth
• Breaking down project costs
• Reviewing cash flow
• Comparing last year to this year
• Showing staff changes in a team

For example, imagine your company made $50,000 last month. This month, you gained $8,000 from new customers. Nice. But you lost $3,000 from discounts and $2,000 from higher costs. Your final result is $53,000. A waterfall chart shows that story clearly.

Why Waterfall Charts Are So Helpful

Waterfall charts are popular because they are easy to read. They also feel like a story. And people love stories more than endless rows of numbers.

A waterfall chart helps you answer questions like:

• What helped us grow?
• What caused the drop?
• Which cost hurt us the most?
• How did we get from point A to point B?

It also makes meetings faster. Instead of saying, “Please look at row 47,” you can point to one bar and say, “This is where we lost money.” Much better.

How to Prepare Your Data

Before you create the chart, you need clean data. Do not worry. This part is easy.

Create two columns in Excel:

• Column A: Labels
• Column B: Values

Your table may look like this:

Use positive numbers for increases. Use negative numbers for decreases. Keep it simple. Excel likes simple.

How to Create a Waterfall Chart in Excel

Now comes the fun part. Let Excel do the heavy lifting.

1. Open your Excel file.
2. Select your data table.
3. Go to the Insert tab.
4. Find the Charts group.
5. Click Insert Waterfall, Funnel, Stock, Surface, or Radar Chart.
6. Choose Waterfall.

That is it. Excel will create the chart for you.

At first, it may not look perfect. That is normal. Charts are like pancakes. The first version is rarely perfect, but it is still useful.

Set Totals the Right Way

This step is important. Excel may treat your final number as another change. But you want it to be a total.

To fix this:

1. Click the bar for your starting value.
2. Right-click it.
3. Choose Set as Total.
4. Do the same for the final value.

Your starting and ending bars should now sit on the baseline. This makes the chart easier to understand.

If you have subtotals, set those as totals too. For example, you may want a subtotal after revenue and another after expenses.

Make Your Chart Look Better

A plain chart works. But a pretty chart works better. It grabs attention. It also makes the message clearer.

Try these quick design tips:

• Use green for increases.
• Use red for decreases.
• Use blue or gray for totals.
• Add a clear chart title.
• Show data labels.
• Remove clutter.
• Keep the background simple.

A good title is not “Chart 1.” Please do not do that to your poor chart. Use something clear, like Monthly Profit Bridge or Cash Flow Changes in April.

How to Read a Waterfall Chart

Reading a waterfall chart is simple. Start on the left. Move to the right.

The first bar is your starting point. The rising bars show gains. The falling bars show losses. The final bar shows where you landed.

Look for the biggest bars first. They show the biggest changes. If a red bar is huge, that is a problem. If a green bar is huge, that is a win. Celebrate, but maybe not with a company yacht.

A Simple User Case Scenario

Let’s say Mia runs a small online store. She wants to understand her profit for May.

She starts with $20,000 in sales. Then she adds $4,500 from a weekend promotion. Great move. She loses $1,700 because of returns. She also spends $2,300 on ads and $900 on shipping.

Her final profit is $19,600.

At first, that sounds confusing. Sales went up, but profit went down. The waterfall chart shows why. The promotion helped. But ads, returns, and shipping pulled the total back down. Mia can now decide what to fix next.

Common Mistakes to Avoid

Waterfall charts are simple. Still, a few mistakes can make them confusing.

• Using too many bars: Keep the chart focused.
• Forgetting negative signs: Costs need minus signs.
• Not setting totals: Start and end values should be totals.
• Bad colors: Use colors that make sense.
• Vague labels: “Other” is not very helpful.

If your chart needs a long speech to explain it, it may need cleaning. A good waterfall chart should make sense in a few seconds.

Best Practices for Using Waterfall Charts

Use waterfall charts when you need to explain movement. Do not use them for everything. They are powerful, but they are not magic glitter.

Here are a few best practices:

• Limit the chart to the most important changes.
• Group small items into one category if needed.
• Use clear labels.
• Add data labels for exact values.
• Keep your colors consistent.
• Use a short title that explains the point.

Also, tell the story out loud. Say what happened. Say what helped. Say what hurt. The chart supports your message.

Final Thoughts

An Excel waterfall chart is a simple way to explain change. It turns boring numbers into a clear visual story. It shows the good, the bad, and the final result.

Use it for budgets, sales, profit, expenses, cash flow, and reports. Keep it clean. Set your totals. Use smart colors. Then let the chart do the talking.

Once you learn it, you may start using waterfall charts everywhere. Be careful. Your spreadsheets might become interesting.