What a bridge chart does and when to use one
A bridge chart (also called a waterfall chart) shows how a starting value changes step by step to reach an ending value. Each bar represents a change — positive or negative — and the bars connect visually so you can see the cumulative effect of each step. The chart literally builds a bridge from one number to another.
Bridge charts work best when you want to explain a financial change: how revenue became profit after subtracting costs, how a budget surplus turned into a deficit, or how a customer count grew from January to December through gains and losses. They're also useful for showing how a project timeline shifted, how a score improved or declined through multiple rounds, or how inventory moved through different stages.
The key advantage is clarity. A single bar chart showing "we started at 100 and ended at 150" doesn't show why. A bridge chart shows the five increases and two decreases that got you there, and the reader can see which steps mattered most.
Key Takeaways
- A bridge chart requires three columns: the category or step name, the change amount for that step, and a helper column that calculates the running total so bars connect properly.
- The starting value and ending value are usually separate rows, with all the changes stacked between them.
- Excel's built-in waterfall chart (available in Excel 2016 and later) handles the math automatically once your data is arranged correctly.
- If you use an older version of Excel, you can build a bridge chart manually using stacked bar charts and hidden helper columns.
Setting up your data for a bridge chart
Start with three columns. Column A holds the step or category names. Column B holds the change amount — positive for increases, negative for decreases. Column C is a helper column that calculates where each bar should start on the chart.
Here's a concrete example. Say you're showing how a $10,000 budget became $8,500 after three changes: a $2,000 increase, a $1,500 decrease, and a $2,000 decrease.
| Step | Change | Helper (Running Total) |
|---|---|---|
| Starting Budget | 10000 | 0 |
| New Revenue | 2000 | 10000 |
| Equipment Cost | -1500 | 12000 |
| Staff Reduction | -2000 | 10500 |
| Ending Budget | 8500 | 0 |
The helper column works like this: for the starting row, enter 0. For each change row, enter the cumulative total before that change. For the ending row, enter 0 again. This tells Excel where to position each bar so they connect visually.
Creating a waterfall chart in Excel 2016 and later
Select all three columns of data, including headers. Go to the Insert tab and click Recommended Charts. Scroll down to find Waterfall, select it, and click OK. Excel will create the chart automatically.
The chart may need formatting. Right-click any bar and select Format Data Series. You can change colors so increases appear one color (usually green) and decreases appear another (usually red). The starting and ending bars often appear in a neutral color like gray or blue.
If the chart doesn't look right, check that your helper column is correct. The most common mistake is forgetting to set the starting and ending rows to 0 in the helper column — this causes those bars to float instead of anchoring to the baseline.
Building a bridge chart manually in older Excel versions
If you're using Excel 2013 or earlier, you don't have the waterfall chart type. You can build one using a stacked bar chart instead. You'll need four columns: the step name, the change amount, a helper column for positioning, and a second helper column that calculates the gap between the baseline and where the bar should start.
The positioning works like this. For each row, the gap column should show the running total up to that point. The change column shows the actual change. When you stack them in a bar chart, the gap pushes the change bar to the right position, creating the bridge effect.
Create a stacked bar chart from your data. Then right-click the gap series (the invisible one) and select Format Data Series. Set the fill to No Fill and the border to No Line. This hides the gap bars while keeping them in place. Now only the change bars are visible, and they appear to float at the correct height.
Labeling and formatting your bridge chart
Add data labels so readers see the actual numbers. Right-click the chart, select Add Chart Element, then Data Labels. Choose to show the values. For a cleaner look, position labels outside the bars rather than inside.
Add a title that explains what the chart shows — not just "Budget Changes" but "How $10,000 Budget Became $8,500." A subtitle or note explaining the time period or context helps readers understand what they're looking at.
Consider adding a horizontal axis label showing the starting and ending values. Some people add a line or annotation showing the total change (in this example, -$1,500). This makes the bottom-line impact obvious at a glance.
Common mistakes and how to fix them
The most frequent error is an incorrect helper column. If bars don't connect or float in the wrong place, recalculate the running total. The helper value for each change row should equal the sum of all changes up to that point, not including the current row.
Another common issue is forgetting to include the starting value as its own row. If you just start with the first change, the chart won't show where you began. Always include a "Starting [whatever]" row with the initial value in the Change column and 0 in the helper column.
If you're using the manual stacked bar method and the gap bars are still visible, make sure you selected the correct series. Right-click directly on the invisible bars (they're there, just hard to see) rather than on the visible ones.
When to use a bridge chart instead of other options
A bridge chart is not the right choice for every situation. If you're comparing independent values with no relationship between them, use a regular bar chart. If you're showing a trend over time where each point is a snapshot, use a line chart.
Bridge charts shine when the story is about how one number became another through a series of steps. They're less useful when you have many small changes — more than about eight or ten steps makes the chart crowded and hard to read. In that case, consider grouping related changes into larger categories.
If your data shows percentages rather than absolute values, a bridge chart still works, but make sure your helper column calculates percentages correctly. The visual effect is the same: readers see how each percentage change contributed to the final result.
Frequently Asked Questions
Can I make a bridge chart in Excel Online?
Excel Online has the waterfall chart type if you're using a recent version. The steps are the same: select your data, go to Insert, choose Waterfall from the chart options. Some formatting options may be limited compared to the desktop version, but the basic chart works.
What if I have negative starting or ending values?
The method works the same way. If you start at -$5,000 and end at $2,000, your starting row shows -5000 in the Change column and 0 in the helper column. The chart will show the bar starting below the baseline and moving up through your changes. The visual story remains clear.
How do I add a total line showing the net change?
You can add a reference line manually. Right-click the chart, select Add Chart Element, then Lines, and choose High-Low Lines or a similar option depending on your Excel version. Alternatively, add a text box or annotation showing the total change amount. Some people add a separate data series that shows only the starting and ending values as a reference.
Can I show multiple bridge charts side by side to compare two scenarios?
Yes. Create two separate charts using the same method, then place them next to each other. Make sure both use the same scale on the vertical axis so readers can compare the magnitude of changes. Label each chart clearly so it's obvious which scenario each one represents.
What's the difference between a bridge chart and a waterfall chart?
They're the same thing. "Waterfall" is the official Excel chart type name. "Bridge" is a descriptive name people use because the bars visually bridge from one value to another. You'll see both terms used interchangeably.