How to Create a Waterfall Chart in Excel (2026 Guide)

If you've ever needed to show how a starting value gets to an ending value through a series of positive and negative changes — quarterly revenue movement, budget-to-actual variance, profit walks, headcount changes — a waterfall chart in Excel is the cleanest way to visualize it. This article walks through exactly how to create a waterfall chart in Excel in 2026 (the native version since Excel 2016), customizations that make it presentation-ready, and the practical scenarios where it's the right call.

Free SEO + AI Search Audit. Waterfall charts visualize how your business gets from A to B. But what about how your business shows up in search — in Google AND in AI platforms like ChatGPT, Claude, Perplexity, and Gemini? Run your free audit → to see exactly where your site stands across every major search and AI platform in 60 seconds.

What Is a Waterfall Chart?

In simple terms, a waterfall chart (sometimes called a "bridge chart" or "flying bricks chart") is a bar chart that shows how a starting value becomes an ending value through a series of intermediate increases and decreases. Each intermediate bar "floats" between the bars on either side of it, visually showing the cumulative effect.

Think of it as a visual story of math. Where a regular bar chart shows discrete categories side-by-side, a waterfall shows the running total: start at $100, add $30 here, subtract $20 there, add $50, end at $160. The eye traces the path from beginning to end and immediately understands what drove the change.

Waterfall charts are a staple of finance, management consulting, and executive reporting. If you've ever sat through a board meeting with "revenue walk" slides, you've seen waterfall charts.

Why Use a Waterfall Chart?

A few specific reasons a waterfall beats other chart types for this use case:

• Shows both totals and individual changes. Viewers see the starting total, ending total, and exactly what contributed to the difference.
• Distinguishes positives from negatives clearly. Typical formatting uses green for increases, red for decreases, and a neutral color for totals.
• Tells a sequential story. The eye naturally reads left-to-right, following the cumulative path.
• Highlights the magnitude of each contributor. It's instantly clear which factor moved the number the most.
• Familiar to executive audiences. Anyone who's seen quarterly earnings presentations recognizes the format.

How to Create a Waterfall Chart in Excel (Step-by-Step)

Since Excel 2016, waterfall charts are a native chart type. The process takes about 60 seconds.

1. Organize your data in two columns. Column A: category labels (e.g., "Starting Revenue," "Product A Growth," "Product B Decline," "New Markets," "Ending Revenue"). Column B: numeric values. Positive numbers for increases, negative numbers for decreases, the starting and ending totals as positive numbers.
2. Select the data range including both columns and any header row.
3. Go to Insert → Charts and click the Waterfall icon (looks like floating rectangles). Excel inserts the chart.
4. Mark the totals. By default, Excel treats all bars as floating intermediate values. You need to tell Excel that the first and last bars are totals (full-height anchored bars, not floating).
   • Click any bar to select all bars
   • Click the first bar (or last bar) again to select just that one
   • Right-click → Set as Total
   • Repeat for the ending total bar
5. Verify colors. Excel auto-applies green to positive bars, red to negative, and a neutral color (usually gray or dark blue) to totals. Customize as needed.
6. Add data labels by clicking the chart → Chart Elements (+ icon) → Data Labels. Each bar will show its numeric value.
7. Add a title and clean up axes. The waterfall is ready for use.

That's it. For more complex waterfalls (subtotals in the middle, stacked bars, conditional formatting), Excel's native chart handles most use cases without add-ins.

Useful Customizations Worth Knowing

A default Excel waterfall chart works. A few customizations make it presentation-ready.

Mark Subtotals

If your waterfall has natural breakpoints (e.g., "Revenue subtotal" between revenue items and cost items), mark those as totals too. Subtotal bars anchor to the baseline like the start/end bars, making the chart easier to read.

Color Your Totals Strategically

Excel defaults totals to gray. For executive reports, use a stronger color (your brand color, or a deep blue) for totals so the starting/ending values visually anchor the chart.

Adjust the Bar Width and Gap

Right-click any bar → Format Data Series → Gap Width. Lower the gap (around 20-30%) for a denser, more "executive deck" feel.

Use Custom Labels

Default labels show the numeric value. To add context (like percent change or driver name), use the Format Data Labels → Value From Cells option and point to a custom column in your source data.

Group Small Drivers

If you have 12 small drivers contributing a few percent each, group them into "Other" to keep the chart readable. Reserve named bars for the 5-7 most material drivers.

Free SEO + AI Search Audit. Waterfall charts show what drove your numbers up or down. The same logic applies to your website traffic — what's driving it, what's killing it, and what's the gap between Google performance and AI search performance? Run a free audit to see exactly where your site stands across every major search and AI platform.

When Should You Use a Waterfall Chart?

Waterfall charts are widely useful but not universally appropriate. Here's when they shine:

1. Revenue or Profit Walks

The classic use case. Show how Q3 revenue became Q4 revenue, broken down by product line, region, or driver. Standard in finance and executive reporting.

2. Budget-to-Actual Variance Analysis

Show how your budgeted number compared to your actual, with each variance driver as a bar. Useful for monthly close presentations or board-of-directors reporting.

3. Headcount and Workforce Movement

For HR and people ops: show how you started the quarter with X employees, hired Y, lost Z to attrition, and ended with W. The waterfall makes the net change instantly visible.

4. Profit Bridge Analysis

For management consulting and corporate strategy: show how price, volume, mix, cost, and FX changes combined to move profit from period A to period B.

5. Funnel Decomposition

For growth and product teams: show how your starting user count became your retained user count through new signups, churn, and reactivation.

Free SEO + AI Search Audit. Whatever waterfall analysis you're running, the underlying question is "what's driving the change?" The same question applies to your search performance. Get a free audit of how your site performs in Google AND in ChatGPT, Claude, Perplexity, and Gemini — and the specific changes driving where you stand.

When NOT to Use a Waterfall Chart

Many small drivers with no clear sequence. Waterfalls assume a logical left-to-right order. If your drivers are unrelated peer categories, use a regular bar chart.

Comparing waterfalls across multiple periods. You can't easily put 12 monthly waterfalls side-by-side. Use a stacked bar chart or a line chart instead.

Showing distribution rather than movement. Waterfalls are about how A becomes B. For "how did this total break down," use a bar chart or pie chart.

Audiences unfamiliar with the format. For purely consumer or non-business audiences, waterfalls can be confusing. Stick with simpler chart types unless you're confident the reader has seen the format before.

Limitations of Excel Waterfall Charts

Customization is more limited than basic bar charts. Excel's native waterfall chart has fewer formatting options than regular bar charts. For highly designed waterfalls, you may end up using a stacked bar chart with invisible series to emulate a waterfall.

No native support for stacked waterfalls. If you want to show drivers broken down by sub-category within each bar, Excel can't do it natively. Workaround: build a stacked bar chart with hidden series.

Subtotals require manual setting. Excel doesn't auto-detect subtotals. You have to right-click each one and set it as total individually.

Mobile and small-screen viewing is poor. Waterfall charts with many bars don't shrink gracefully. For mobile-first dashboards, use simpler visualizations.

Pre-2016 Excel doesn't support it natively. If you're stuck on Excel 2013 or earlier, you'll need to build waterfalls manually using stacked bar charts and invisible series — much more work.

Connecting lines between bars aren't native. Some style guides expect dotted lines connecting the top of one bar to the bottom of the next. Excel doesn't draw them; you'd need to add them as drawn shapes (which don't move with the data).

Final Thoughts

A waterfall chart in Excel is the right tool when you need to tell a sequential story about how one number became another. For finance, executive reporting, and management consulting work, it's a standard format with high recognition. For other types of analysis, a different chart type usually serves better.

Whatever the chart, the data visualization is only the beginning. The bigger question for most businesses in 2026 is what's actually driving traffic, leads, and revenue — and increasingly, the answer is changing as buyers move from Google search to ChatGPT, Claude, Perplexity, and Gemini for product recommendations. Most teams have no visibility into how they perform in those AI answers. Run a free audit to see exactly where your site stands across Google AND every major AI search platform — and which fixes will move your traffic the fastest this quarter.