An Excel waterfall chart is a specialized column chart that visually breaks down how a starting value increases and decreases to arrive at a final total. Instead of presenting changes as isolated numbers, it clearly shows the cumulative impact of each positive and negative contribution along the way. This makes it particularly effective for explaining variance, profit and loss drivers, budget changes, or step-by-step performance shifts.

The chart solves a common reporting problem: stakeholders often struggle to understand how individual movements combine to produce a net result. By mapping each change sequentially, a waterfall chart turns complex calculations into an intuitive visual story. It is widely used by finance teams, business analysts, and managers who need to communicate results with their P&L statements, product earning reports or inventory.

In this guide, you will learn how to create, format, and customize an eye-catching waterfall chart in Excel to present your data clearly and professionally.

What is an Excel Waterfall Chart?

An Excel waterfall chart (sometimes called a cascade chart) visualizes how a number changes step by step to reach a final result. Rather than displaying values independently, it connects each positive and negative change in sequence so you can clearly see how the total evolves over time. 

Every waterfall chart follows a simple logic and includes the following:

• Starting value – the baseline or opening number (for example, beginning revenue, budget or inventory).
• Positive changes – gains that push increase the total, such as new sales or cost savings.
• Negative changes – losses or expenses that decreases the total.
• Ending value – the final outcome after all increases and decreases are applied.

Each additional value “floats” from the previous one to visually reinforce how every component contributes to the overall result. 

You may also hear the term bridge chart. A bridge chart is simply a variation of a waterfall chart that includes subtotals at key points to highlight intermediate stages. While all bridge charts are waterfalls, not every waterfall includes these extra subtotal markers. Both formats serve the same purpose: explaining how you move from point A to point B.

Compared to a standard column chart, a waterfall chart is far more effective for explaining change. A regular column chart shows separate bars with no relationship between them, forcing viewers to calculate differences themselves. A waterfall chart does that work visually, making the story behind the numbers immediately clear and easier to understand at a glance.

When should you use an Excel waterfall chart?

Waterfall charts are widely used in corporate, finance, and operations reporting because they clearly explain how individual values contribute to changes in a key number. Instead of simply showing totals, they reveal the positive and negative drivers behind those totals, making it clear what increased the figure, what reduced it, and how everything adds up.

Here are some common scenarios when it makes sense to use a waterfall chart:

• Product value analysis – show how pricing, volume, discounts, and returns impact total revenue over a period of time.
• Profit and loss statements – illustrate how individual components like revenue, costs, and expenses contribute to overall profit or loss, offering clear visual insights into financial performance
• Budget changes on a project – display variance highlights in budgets more clearly by showing increases or decreases and helping track financial shifts over time.
• Cash flow statements – break down data to easily track your cash flow and identify trends, risks, and opportunities. 
• Sales or KPI performance reviews – explain what specifically drove growth or decline
• Inventory or sales analysis – visually represent changes in inventory or sales, pinpointing trends and helping identify areas for improvement. 
• Sales dashboards – provide concise, high-level views of key metrics (like sales growth), making complex data accessible and actionable for executives.

Because each bar builds on the previous one, stakeholders can quickly see not just what changed, but why it changed.

Tip: You can also add subtotals as checkpoints within the sequence. These act as visual milestones in your data. For example, you could use Net revenue and Gross Income as checkpoints between Gross Revenue and Net incomestarting and ending values.

Use a waterfall chart when

• You have a clear starting value and ending value
• You need to explain the factors driving patterns, not just totals
• The goal is variance analysis or contribution analysis
• Categories are limited and meaningful (so each step tells a story)

Don't use a waterfall chart when

• There are too many categories, which makes the chart cluttered and hard to read
• There is no logical start or end point, which are needed to tell the story
• You are showing trends over time only in which case a line or a column chart is a much more suitable choice.

In short, choose a waterfall diagram when you want to explain how you got from one number to another. 

Real-world Excel waterfall chart examples

Revenue change (Year over Year)

A good example of a waterfall chart in Excel is a simple YoY comparison, such as “Revenue grew 8% YoY” lacks the context necessary for making informed business decisions. What’s actually needed is a way to clearly understand individual contributing factors, such as better pricing, higher demand, or customer growth. You need to understand these drivers because they have very different implications for your strategy and sustainability.

Revenue bridge analysis is a powerful tool for taking revenue values in two periods and pinpointing the causes driving financial performance, such as volume, price and customers. 

The structure typically follows a clear business sequence:

• Starting revenue – Last year’s baseline revenue
• Price impact – Increases or decreases driven by pricing changes. A positive price effect indicates that a revenue increase is a result of higher prices. A negative effect might point to increased discounting or competitive price pressure.
• Volume impact – The impact tells you how much of your revenue change is due to an increase or decrease in overall sales volume. Positive impact means more units sold as a result of effective marketing.
• New customers – Revenue from customer acquisition or churn. A positive customer impact suggests successful acquisition, expansion into new segments, or improved retention strategies. A negative impact highlights churn, contract losses, or reduced customer lifetime value. 
• Ending revenue – Current year’s total revenue.

Each step in a revenue waterfall chart in Excel quantifies how much that factor contributed to growth or decline, creating a transparent bridge between the two periods.

Structuring your waterfall around these drivers supports sharper decision-making. Leadership can quickly determine whether growth came from pricing power, higher demand, or customer expansion and adjust strategy accordingly. For example, customer-driven growth may justify more marketing investment, while price-driven gains may require monitoring competitiveness.

Profit bridge

A profit bridge is a focused type of Excel waterfall chart used to explain how your organization moves from one profit figure to another. Rather than presenting profit as a single outcome, it breaks the number into the key business drivers that increased or decreased performance along the way.

This approach is especially useful in financial reviews because profit is rarely driven by just one factor. Revenue, costs, and expenses all shift at the same time, and a bridge chart shows how those movements combine to produce the final result.

A simple, practical structure includes the following steps:

• Starting profit – This is the baseline, typically last period’s profit or the budgeted profit target
• Revenue – This data point captures the impact of selling more or less, changing prices, or improving product mix. Positive revenue signals stronger demand or better execution.
• Cost changes – These are direct costs tied to producing goods or delivering services. Reduced costs usually mean better margins and improved profit.
• Operating expenses – These include indirect or overhead costs such as marketing, administration, rent, software, and support functions.
• Final profit – The ending profit after all impacts are applied

A simple profit number does not reveal whether performance improved because of stronger sales or tighter cost control. This inability to clearly understand the reasons behind profit drivers prevents the management from focusing their efforts correctly.

A profit waterfall chart helps organizations identify margin improvement opportunities or control or reallocate spending. In short, the profit bridge connects financial outcomes to operational causes, turning profit analysis into clear, actionable insight rather than a headline number.

Budget vs. actuals variance analysis

One of the most practical examples of an Excel waterfall chart is explaining budget versus actual variance. It helps organizations identify the areas in which they missed the budget and the reasons behind the variance. The variance analysis may look at revenues, expenses, volume, sales mix and prices. 

Depending on which variance users are looking at, the factors may include differences in sales, cost fluctuations, timing differences, inaccuracies in forecasting or budgeting, and external factors. For example, an unplanned increase in expenses may be the result of a large increase in wages or minor increases over five categories. These scenarios require completely different responses and a clear analysis may help the organization decide on the best course of action. 

In a budget vs. actual waterfall chart, the structure typically looks like this:

• Starting value – Budgeted total (planned spend or revenue target)
• Positive variances – Favorable impacts that result from cost savings, higher revenue, and efficiency gains.
• Negative variances – Unfavorable impacts that include overspending, delays, lower sales, and unexpected expenses.
• Ending value – Actual result

Using a waterfall for variance analysis improves the quality of financial reviews and planning discussions because it:

• Clarifies accountability by linking changes to specific categories
• Helps prioritize cost controls or reinvestments
• Provides evidence for adjusting future budgets
• Makes complex reconciliations easier for non-financial stakeholders to understand

How to create a waterfall chart in Excel

Creating an Excel waterfall chart is primarily a matter of structuring your data correctly and then telling Excel which columns represent totals. The chart engine does most of the work automatically, but mislabeling totals or cluttering the layout can quickly make the result confusing.

Below is a clear, step-by-step Excel waterfall chart tutorial for both basic and more advanced use cases.

Basic Waterfall Chart (Two Totals)

This is the most common format and works well for scenarios like revenue change, budget vs. actual, or year-over-year comparisons where you have one starting value and one ending value. 

Step 1: Prepare your data

Set up two columns:

• Column A: Categories (labels)
• Column B: Values (positive and negative changes)

Structure the data in logical order:

• Starting total (e.g., 2021 revenue or Budget)
• Individual positive and negative contributions
• Ending total (e.g., 2022 revenue or Actual)

Keep the sequence aligned with the story you want to tell. Waterfall charts are chronological or logical, not alphabetical.

Step 2: Insert the waterfall chart

Select the full data range

Go to the Insert tab

Choose Waterfall or Stock Chart → Waterfall

Excel will automatically color increases, decreases, and totals differently.

Step 3: Set your totals correctly

This step is critical.

Excel treats every bar as a change unless you explicitly mark totals.

• Click the starting value column
• Right-click → Set as Total
• Click the ending value column
• Right-click → Set as Total

If you skip this step, the chart will calculate incorrectly and “float” from the wrong baseline.

Step 4: Declutter the chart

By default, Excel adds visual elements that often distract from the message.

• Click the chart
• Select the + (Chart Elements) icon
• Remove:
  • Gridlines
  • Legend (colors already indicate increases/decreases)
  • Primary Vertical Axis 
• Rename the title to something descriptive or add a title line above so the chart doesn’t start from zero.

Cleaner charts are easier for stakeholders to interpret quickly.

Step 5: Improve visibility of small contributions (optional)

If some bars are too small to see:

• Add back the Primary Vertical Axis
• Right-click → Format Axis
• Adjust the Minimum bound to zoom into the relevant range

This improves readability, but use carefully, since the chart will no longer visually start at zero.

Advanced Waterfall Chart (Multiple Totals)

For an advanced waterfall chart follow the tutorial for creating a basic waterfall chart in Excel above. The only difference is that you introduce multiple subtotal checkpoints instead of just one starting and ending total.

This format is useful when you want to show how a number evolves through several logical stages. For example, you might want to use Net revenue and Gross Income as checkpoints between Gross Revenue and Net income starting and ending values.

Each subtotal acts as a “pause point” that shows the cumulative result before moving to the next set of drivers.

How it differs from a basic waterfall

The chart creation steps are exactly the same. The only additional action is:

Mark every subtotal column as Set as Total, not just the first and last bars

Without this step, Excel will treat subtotals as regular changes and the math will be incorrect.

Limitations of Excel Waterfall Charts

While Excel is the industry standard for spreadsheet work, its native waterfall chart functionality is not perfect. As datasets grow and reporting becomes more complex, several practical limitations start to appear. Here are some of the most common: 

Heavy Manual Data Prep: Waterfall charts rely on clean and structured input data. You must manually organize categories, calculate positive and negative changes, and ensure totals are placed in the correct positions as Excel does not understand business logic such as subtotals or intermediate checkpoints.

Hard to maintain and update: Because these charts are sensitive to data structure, something as simple as adding a new revenue category or changing a subtotal can break your Excel waterfall chart. Reformatting and relabeling totals and categories adds unnecessary friction to regular reporting.

Easy to misinterpret: Some common issues include too many bars, unclear categories or wrong scale can cause readers to fail to immediately grasp the relative impact of a change.

Static visuals: Excel waterfall charts are largely static and lack dynamic filtering, drill-downs, automatic updates from live data and interactive exploration.This limits their usefulness in dashboards or environments where users need to explore different scenarios quickly.

This is where specialized tools can help

For teams that have outgrown manual data entry, the focus shifts from building the chart to analyzing the insights. This is the logic behind Zebra BI. Instead of fighting with Excel’s formatting quirks, Zebra BI automates the heavy lifting. It allows you to create dynamic, IBCS-compliant waterfall charts that handle subtotals automatically, offer drill-down capabilities, and ensure your "last mile" of analytics is spent telling the story, not fixing the formatting.

Common Mistakes with Excel Waterfall Charts

Waterfall charts are powerful when used correctly, but they are also easy to misuse. Most problems stem from either overcomplicating the chart or structuring the data poorly. The result is a visualization that confuses rather than clarifies.

Below are the most frequent mistakes to avoid.

1. Too many bars

Trying to show every minor driver of your KPIs creates clutter and reduces readability. When a chart has 15–20 small steps, the arc of your story gets lost in details.

Fix: Focus only on the biggest contributors that explain most of the change or group smaller items into a single category. 

2. Missing or unclear totals

If starting, ending, or subtotal columns are not marked as Set as Total, Excel treats them as incremental changes. This produces incorrect floating bars and misleading results.

Fix: Always explicitly set totals and double-check that they anchor to the baseline.

3. Misleading or inconsistent colors

Random color choices make it harder to interpret gains and losses. Worse, inconsistent use (e.g., red for positive in one chart and negative in another) creates confusion.

Fix: Use consistent conventions, such as positive values in green, negative values in red, and totals in a neutral color, which is a common approach in financial reporting.

4. Using a waterfall when another chart fits better

Waterfall charts are designed to explain step-by-step change and highlight contributions. They are not ideal for trends or simple comparisons.

Fix: To show trends over time use a line chart. Category comparisons are best displayed with a column/bar chart and single differences are most effectively displayed with a variance chart. Only use a waterfall when you need to explain drivers between two values.

5. Showing irrelevant or trivial changes

Including small or low-impact categories distracts from the main message and weakens the analysis.

Fix: Focus on significant drivers that should be addressed by your decisions. Minor contributors are often just noise that can drown out your story. 

6. Poor data ordering

Sorting categories alphabetically or by size breaks the logical flow of the story.

Fix: Order steps according to business logic (chronological or causal sequence).

7. Cluttered charts

Gridlines, legends, heavy borders, and extra labels add visual noise without improving understanding.

Fix: Remove anything that does not directly support interpretation.

Excel Waterfall Chart vs Similar Charts

When deciding when to use waterfall charts you should know how they compare to other types, such as variance and bridge charts. While they look similar, each serves a slightly different purpose.

Waterfall Chart vs Variance Chart

A waterfall chart in Excel explains how multiple drivers move a number from a starting value to an ending value. It shows the cumulative impact of several positive and negative contributions in sequence. It is best for:

• Revenue drivers (price, volume, customers)
• Profit or margin breakdowns
• Comparing budget vs. actual values

Essentially, variance reports show the difference between the planned or past financial outcomes and the actual financial outcomes (e.g., Budget vs. Actual, Plan vs. Forecast). It shows the size of the difference but does not explain what caused it. No organization can expect to make informed decisions without having this insight and variance reports are all about providing it.

Use a variance chart when you only need to show the magnitude of change at a high level and use a waterfall chart when you need to explain the drivers behind that change. If you want to answer the question of Why, you need a waterfall chart.

Waterfall Chart vs Bridge Chart

A bridge chart is essentially a structured subtype of a waterfall chart that includes explicit subtotals or milestones between the starting and ending values. Instead of showing one continuous start-to-finish flow, it breaks the journey into logical stages and highlights the cumulative result at each checkpoint.

This format is useful when you want to show how a number evolves through several business steps rather than just a single overall change. For example, you might move from Gross Revenue → Net Revenue → Gross Income → Net Income, with each subtotal acting as a clear performance milestone.

Bridge charts are best for:

• Income statement or profit walk-throughs
• Financial statements with natural stages (revenue → margin → profit)
• Multi-step calculations that leadership reviews separately
• Situations where intermediate results matter as much as the final total

A standard waterfall chart focuses on explaining one overall change between a start and an end. A bridge chart adds structure by emphasizing the checkpoints in between.

Use a waterfall chart for simpler stories with one start and one end. Use a bridge chart when you need to show meaningful intermediate stages and how each stage contributes to the final outcome.

How to Interpret an Excel Waterfall Chart

Waterfall charts are not just about showing numbers. Creating them is only half the job. The next step is to interpret data and turn them into clear and actionable conclusions. Use waterfall charts in your analysis as a diagnostic tool for your data to see what drove change and pinpoint where you need to focus your efforts.

Identify the main drivers

Start with a quick review of the chart and look for bars that stand out - either in positive or negative direction. These are the drivers that contributed the most to any changes you see in your data and here is where you need to focus your attention.

A useful question to ask yourself is “Which 2 or 3 steps explain most of the movement in my data?”. Once you have the answer, you are on your way to focusing your attention productively. 

Read magnitude and direction correctly

Each bar in a waterfall chart communicates two things:

• Direction and the color: Did it increase or decrease the total? Most waterfall charts use color-coding - green for positive (increases), red for negative (decreases), and grey for the totals.
• Magnitude: How much impact did it have? The vertical height of the bar represents the absolute value of the change. The longer the bar, the larger its impact. 

Waterfall charts clearly show that not all changes are created equal. Some have a major impact on your results while others might be just a blip on an otherwise positive trajectory. 

Understand what the chart can tell you

A waterfall chart is a powerful tool for explaining contribution and causality. You can see which factors drove results and how you got from point A to point B. Individual bars allow you to see the net impact of individual drivers and compare their relative importance.

On the other hand, you cannot see the reasons behind the changes. While the chart may show a $50k negative impact of churn, it does not explain why those customers left. It also cannot show whether a change like that is one-time or recurring.

Essentially, It explains what changed, not why it changed at a deeper operational level or what will happen next. It serves as a tool to focus your attention on individual areas and start looking for root causes and ways to address them.

Turn the chart into a clear explanation

When presenting a waterfall chart, avoid narrating every step and getting bogged down in details. After all, it is a great tool to focus your attention. Tell a story following this simple structure: 

1. Start with the baseline
2. Highlight the biggest positive drivers
3. Highlight the biggest negative drivers
4. State the net effect

For example: “Revenue increased by $2M, mainly driven by higher pricing and new customers, partially offset by higher operating costs, resulting in a $500K net profit increase.” At its core, a waterfall chart is doing its job, when the user can see what changed and what should be acted upon.

Frequently Asked Questions