What a bridge chart shows and why you might build one

A bridge chart (also called a waterfall chart) is a visual way to show how a number changes from a starting point to an ending point, with each step visible in between. Instead of just showing "we started at 100 and ended at 150," a bridge chart breaks down exactly which changes pushed the number up and which pulled it down.

The chart looks like a series of floating bars connected by a line. The first bar sits on the axis. Each bar after that floats at the height where the previous change ended. This makes it straightforward to see at a glance which factors moved the needle most and in which direction.

You might use one to show how revenue changed month to month, how a budget surplus or deficit built up, how inventory levels shifted, or how a project timeline slipped. Any situation where you want to show the path from point A to point B, not just the distance between them, is a good fit for a bridge chart.

Key Takeaways

  • A bridge chart requires three columns: a label column, a value column for the size of each change, and a hidden column that positions each bar at the right height on the chart.
  • The positioning column uses formulas to add up all the changes that came before, so each bar starts where the last one ended.
  • You build the chart by stacking two data series on top of each other — one invisible series that creates the gap, and one visible series that shows the actual change.
  • Excel does not have a built-in bridge chart type, so you have to use a stacked column chart and format it to look like a bridge.

Set up your data in three columns

Start with a blank area of your spreadsheet. You need at least three columns: one for labels, one for the actual values (the changes you want to show), and one for positioning.

In column A, type your labels. These might be "Starting Balance," "Sales," "Returns," "Discounts," "Ending Balance" — whatever the steps in your story are. In column B, type the values. For increases, use positive numbers. For decreases, use negative numbers. For the starting and ending points, use the actual balance or total, not a change.

Column C is where the positioning math happens. This column will be invisible in the final chart, but it tells Excel where to draw each bar. Leave the first row blank (or put 0). In the second row, type a formula that adds the first value to zero: =B1. In the third row, type =C2+B2. Copy that formula down to the rest of the rows. What this does: each cell adds the current change to the sum of all changes before it, so each bar knows where to start floating.

Create the stacked column chart

Select all three columns including headers. Go to the Insert tab and choose Column Chart, then pick the Stacked Column option (not the 3D version). Excel will create a chart with two series stacked on top of each other — one from column C (the positioning) and one from column B (the actual values).

The chart will not look like a bridge yet. It will look like two sets of stacked bars. That is normal. You are about to hide the first series and format the second one.

Hide the positioning series and format the values

Right-click on the chart and choose "Select Data." You will see two series listed: one for column B and one for column C. Click on the series for column C (the positioning column) and remove it from the chart, or click on it in the chart itself and delete it. The bars will drop down to the axis.

Now right-click on one of the remaining bars and choose "Format Data Series." Set the gap width to 0 so the bars sit next to each other with no space. You can also change the color here — many bridge charts use one color for increases and another for decreases, though that requires splitting the data into two series. For now, a single color is fine.

If you want to show increases and decreases in different colors, you will need to split column B into two columns: one for positive values and one for negative values (shown as positive numbers). Then add both to the chart as separate series and format each one a different color. This takes a few extra steps but makes the chart much easier to read at a glance.

Add data labels so the numbers are visible

Right-click on the bars and choose "Add Data Labels." The labels will appear on top of each bar showing the value. You can format these labels to show currency, percentages, or plain numbers depending on what you are tracking.

If the labels are hard to read, right-click them and choose "Format Data Labels." You can move them inside the bars, outside the bars, or to the center. You can also choose to show only the label text without the value, or only the value without the label.

Add a title and clean up the axes

Right-click the chart title and edit it to something clear like "Revenue Bridge: January to March" or "Budget Variance Waterfall." Make sure anyone reading the chart knows what they are looking at and what time period or scenario it covers.

Check the vertical axis. It should start at 0 and go high enough to show your largest bar comfortably. If the axis is showing negative numbers and you do not have any negative values in your chart, right-click the axis and set the minimum to 0. You can also hide the horizontal axis labels if they are cluttering the chart — the labels on the bars themselves are usually enough.

Frequently Asked Questions

Can I show increases and decreases in different colors?

Yes, but it requires splitting your data. Create two value columns instead of one: one for increases (positive numbers) and one for decreases (shown as positive numbers). Add both as separate series to the chart and format each a different color. The positioning column stays the same.

What if my starting value is not zero?

Put the actual starting value in the first row of column B, not zero. The positioning formula in column C will still work — it will add that starting value to the first change, and each bar will float at the right height. The chart will show the path from your actual starting point to your ending point.

How do I update the chart when my data changes?

Change the numbers in columns B and C, and the chart updates automatically. If you add new rows, select the chart, go to Select Data, and expand the data range to include the new rows. The positioning formulas in column C will calculate correctly for any new changes you add.

Can I make the bars narrower or wider?

Right-click the bars, choose Format Data Series, and adjust the gap width. A gap width of 0 makes bars touch. Higher numbers add space between them. You can also change the bar width as a percentage of the available space.

What if I want to show this data as a line chart instead?

A line chart will not work well for a bridge because it connects the tops of the bars, not the values themselves. The stacked column approach is the standard way to build a bridge chart in Excel. If you want a different look, consider a combo chart with columns and a line, but the bridge effect will be lost.