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

A bridge chart — also called a waterfall chart — is one of the most useful visualization tools for showing how an initial value changes through a series of gains and losses to reach a final result. Finance teams use them to break down profit and loss statements. Project managers use them to track budget variances. Analysts use them to explain the moving parts behind any net change.

Excel has supported waterfall charts natively since Excel 2016, but the method you use — and how much control you get over the result — depends heavily on your version, your data structure, and exactly what story you're trying to tell.

What a Bridge Chart Actually Shows

The defining feature of a bridge chart is the floating bar — bars that don't start at zero. Instead, each bar picks up where the last one left off, visually bridging from one value to the next.

A typical bridge chart includes:

• A starting value (e.g., opening revenue or beginning balance)
• A series of positive changes (increases, gains, additions)
• A series of negative changes (decreases, costs, losses)
• An ending value (e.g., closing balance or final total)

The visual effect makes it immediately clear not just what changed, but how much each factor contributed to the overall shift.

Method 1: Using Excel's Built-In Waterfall Chart (Excel 2016 and Later)

This is the fastest route if you're on a modern version of Excel. 📊

Step 1: Structure your data

Set up two columns — one for category labels and one for values. Positive changes are entered as positive numbers; negative changes are entered as negative numbers. Your starting and ending totals are separate rows.

Step 2: Insert the chart

Select your data range, go to Insert → Charts → Waterfall (it looks like a series of ascending and descending bars). Excel will generate a chart automatically.

Step 3: Mark totals correctly

This step is critical and easy to miss. Excel treats every bar as an incremental value by default — but your Starting Balance and Ending Balance are absolute totals, not changes. Right-click each of those bars and select "Set as Total". This anchors them to the baseline instead of floating.

Step 4: Format for clarity

• Right-click bars to change fill colors for positive vs. negative values
• Add data labels so readers can see exact figures without reading the axis
• Adjust the gap width under Format Data Series to control bar thickness

Method 2: Stacked Bar Workaround (Excel 2013 and Earlier)

If you're working on an older version of Excel — or if you need finer control over formatting — you can build a bridge chart manually using a stacked bar chart with invisible segments.

This method requires three data series:

1. Base (invisible): the hidden "riser" that elevates each visible bar to the correct starting height
2. Increase: visible green bars
3. Decrease: visible red bars

The logic: each visible bar sits on top of an invisible base. The base height equals the cumulative running total at that point in the series. You then format the base bars to have no fill and no border — they disappear visually but still lift the chart bars to the correct position.

This approach involves more spreadsheet math and formatting steps, but it gives you pixel-level control over every visual element — something that matters in formal reports or presentations where brand colors and exact styling are required.

Key Variables That Affect Your Approach 🔧

Excel version is the biggest fork in the road. The native waterfall chart is only available in Excel 2016 and later (including Microsoft 365). If you're on Excel 2013 or an older perpetual license, the stacked bar method is your only in-app option.

Data complexity matters too. Simple, linear datasets (one metric changing over time) work cleanly with both methods. More complex scenarios — multiple sub-categories, conditional breakdowns, or nested hierarchies — often require the manual stacked bar approach or a dedicated data visualization tool altogether.

Presentation context shapes formatting decisions significantly. A quick internal analysis might need nothing beyond Excel's defaults. A board-level deck or published report often demands custom colors, precise label positioning, and design alignment that the manual method handles better.

Technical comfort level is a real factor. The built-in waterfall chart can be configured in under ten minutes by someone with moderate Excel experience. The stacked bar workaround requires understanding of running totals, series stacking logic, and Excel's formatting layers — it's achievable but has a steeper learning curve.

Common Mistakes to Avoid

• Not setting totals: Forgetting to mark starting and ending values as totals is the most common error with the built-in method. Those bars will float incorrectly until you fix this.
• Negative numbers in the wrong direction: In the manual method, which series a value belongs to (increase vs. decrease) has to be assigned explicitly — Excel won't infer intent from sign alone.
• Overcrowding the chart: Bridge charts lose readability quickly when too many categories are stacked. If you have more than eight to ten segments, consider grouping smaller items into an "Other" category.
• Skipping axis labels and titles: A floating bar with no context is just a visual puzzle. Clear axis labels and a descriptive chart title do most of the interpretive work for your audience.

How the Same Tool Looks Different Across Use Cases

A financial analyst building a P&L bridge with 15 line items has meaningfully different needs than a project manager showing a three-phase budget variance. The former might need sub-totals mid-chart (which the native waterfall supports via additional "total" bars); the latter might only need a clean, high-contrast visual for a slide.

Even within the same organization, two people building bridge charts in Excel can arrive at completely different solutions — and both can be correct — depending on their version, their audience, and how much post-build formatting control they need.

The method that works best for your situation comes down to what you're starting with and what the finished output needs to do.