Revenue Waterfall Chart in Excel: Build and Format One

To make a revenue waterfall chart in Excel for Microsoft 365, put the opening revenue and each increase or decrease in a single value column, select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Mark the opening and ending revenue bars as totals so Excel shows the steps between them as a bridge.

What a revenue waterfall chart shows

A revenue waterfall, also called a revenue bridge, explains how a starting figure changes into an ending figure. Instead of showing only two totals, it displays the individual drivers between them. A company might use one to explain why revenue rose or fell from one quarter to the next, or how a forecast differs from a prior plan.

Each intermediate bar represents a change, not a new revenue total. Positive changes move the running total upward; negative changes move it downward. The bars appear to float at the level reached after the preceding steps. The first and last bars are usually full-height totals, which give the reader clear starting and ending points.

This makes a waterfall useful when the question is “What caused the change?” A line chart can show the overall trend across many periods, while a waterfall focuses on the components of one movement. It does not, by itself, prove why a change happened: the categories and figures still need to be supported by sound records and a consistent definition of revenue.

Arrange the source data

Excel’s built-in waterfall chart expects category labels in one column and the corresponding amounts in another. Put the opening balance first, the drivers in the order you want readers to follow, and the ending balance last. Enter increases as positive numbers and decreases as negative numbers. Do not calculate a running total in every row; Excel accumulates the intermediate changes for the chart.

For example, a quarterly bridge could use these illustrative amounts, in thousands of dollars:

Prior-quarter revenue: 1,000
New customers: 180
Expansion: 90
Churn: -70
Contraction: -40
Foreign-exchange effect: 20
Current-quarter revenue: 1,180

The drivers net to an increase of 180, so the ending revenue is 1,180. Keep the same units throughout: mixing dollars and thousands of dollars can create a chart that looks plausible but is wrong by a factor of 1,000. Use labels that describe the business change, not vague terms such as “other” unless the underlying contribution is genuinely a single, small residual.

Create the chart in Excel

Enter the category names in column A and the amounts in column B, with headers such as Category and Amount.
Select the full range, including the headers and the opening and ending rows.
On Windows, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. If the chart button is displayed as an icon, open its dropdown and choose Waterfall.
Excel creates the chart with the intermediate values treated as changes. The first and last rows may initially appear as changes too, so set those two bars as totals.
Add a descriptive chart title and check the units, labels, and direction of the changes before sharing it.

On current Excel for Mac versions, use the Insert tab and the Waterfall chart option; the chart formatting controls may be arranged differently from Windows. If a right-click menu is needed on a Mac, Control-click the bar. The steps and names above refer to the desktop Excel interface, not Google Sheets. In either operating system, Ctrl+Z on Windows or Command+Z on Mac undoes the last edit.

Set the opening and ending bars as totals

This step is essential. Click the opening bar once to select the series, then click that same bar again to select just that data point. Right-click it and choose Set as Total. Repeat for the ending bar. On Mac, Control-click the selected point to open its context menu. The exact menu presentation can vary slightly by release, but Set as Total is the command that makes the selected bar start from the chart’s baseline rather than float as another change.

A total bar is not an instruction for Excel to add that row to the running balance. It is a visual anchor showing an absolute value. Intermediate categories remain increases or decreases. If a subtotal occurs midway through the bridge, such as revenue at the end of each month, mark that subtotal as a total too. Use this sparingly: too many total bars can interrupt the story and make the sequence harder to follow.

If you update the underlying data later, check that the intended total points are still marked correctly. Inserting or rearranging rows can change which category occupies a particular position, and a chart that still looks familiar may no longer communicate the right start and finish.

Worked example and a simple total formula

In the example, start at 1,000, then add 180 for new customers and 90 for expansion. Subtract 70 for churn and 40 for contraction, then add 20 for the foreign-exchange effect. The arithmetic is 1,000 + 180 + 90 – 70 – 40 + 20 = 1,180. The chart should therefore begin at 1,000 and end at 1,180, with the six middle bars showing those movements in order.

If the category labels are in A2:A8, the opening amount and five drivers are in B2:B7, and the ending total is in B8, enter this formula in B8:

=SUM(B2:B7)

For the example values, the formula returns 1,180. Select A1:B8 if row 1 contains the headers, insert the waterfall, and set the first and last bars as totals. This formula is appropriate only when B2:B7 contains the opening amount plus all the intervening changes. If the ending revenue comes from an independently reported source, it can be better to enter that verified figure directly and use a separate reconciliation to investigate any difference.

Format the chart for clear reading

Formatting should make the logic easier to see, not decorate away uncertainty. Give the chart a title that names both the measure and comparison, such as “Revenue change, Q1 to Q2 ($000s).” If the number scale is not obvious, include the unit in the title or axis label. Add data labels when readers need exact contributions, but avoid crowding every small bar with a label if the chart becomes difficult to scan.

Use a consistent number format, including separators and currency symbols where appropriate.
Keep the categories in a logical sequence, such as customer gains, expansions, reductions, and final total.
Make positive, negative, and total bars visually distinguishable. Do not rely on color alone; labels and position should also convey meaning.
Use concise category names and explain uncommon abbreviations in a note or nearby text.
Check that the vertical axis and labels do not imply more precision than the source data supports.

Excel assigns different colors to increases, decreases, and totals by default, but theme settings and formatting edits can affect appearance. Review the chart after applying a workbook theme or copying it into a presentation. For accessibility, verify that the distinction remains understandable in grayscale or for a reader who cannot distinguish the chosen colors.

Choose meaningful revenue categories

The most useful categories are those that explain a decision or reconcile to the organization’s reporting. Depending on the business, drivers may include new customers, renewals, expansion, churn, price changes, product mix, acquisitions, or foreign exchange. The right categories depend on the question and the company’s accounting or management definitions; there is no universal list that fits every revenue bridge.

Keep categories mutually exclusive where possible. If “price increase” already includes the effect of customer upgrades, counting the upgrade again under “expansion” double-counts revenue. Similarly, separate operational changes from currency translation only when the source data supports that distinction. A bridge can include a small “Other” category, but a large unexplained amount is a signal to investigate the inputs rather than hide the gap.

Be precise about the revenue measure and period. Recognized revenue, bookings, annual recurring revenue, and cash receipts are not interchangeable. A chart should say which measure it uses and compare like with like, such as the same fiscal period under consistent definitions. If a period is restated or the reporting basis changed, note that context so readers do not interpret a methodological difference as business growth or decline.

Common problems and how to fix them

The final bar does not match the reported ending figure: Recheck the sign of each driver, confirm that every relevant category is included, and compare the bridge total with the source report. Do not force a match by changing a value without documenting the reason.
The first or last bar floats: Select that individual bar and use Set as Total. A normal increase or decrease starts from the preceding cumulative level; an absolute total starts from the baseline.
All bars appear to rise: Confirm that decreases are entered as negative numbers. A label that says “Churn” does not make a positive value subtract from the running total.
The chart looks cluttered: Combine only categories that are genuinely related, shorten labels, or show a detailed reconciliation in a table beside a simpler chart. Do not combine items in a way that conceals a material driver.
Excel plots the data in an unexpected direction: Check that each category is on its own row and that the selected range includes the intended label and amount columns. If necessary, use Chart Design > Switch Row/Column, then verify the result.

For an additional check, independently calculate opening revenue plus all signed changes and compare it with the closing revenue. This reconciliation catches errors that a visually attractive chart cannot: a waterfall will faithfully display incorrect source numbers.

Waterfall charts compared with alternatives

Use a waterfall when the purpose is to explain a start-to-finish change through additive components. A clustered column chart is often better for comparing separate revenue totals across products, regions, or periods, because each bar shares a baseline. A line chart is usually more suitable for showing a trend across many time periods. A table may be clearer than any chart when there are only a few figures and exact values matter more than the visual explanation.

Excel’s native waterfall is convenient for a standard bridge because it handles cumulative positioning and provides total-bar formatting. A manually constructed stacked-column chart can offer more control over specialized layouts, but it requires helper series and careful maintenance. For most straightforward revenue bridges, start with the built-in chart; consider a custom construction only if a specific reporting requirement cannot be met with its formatting options.

Frequently Asked Questions

Can Excel make a revenue waterfall chart automatically?
Excel can create the chart from category labels and values using its built-in Waterfall chart type. It does not know which categories are business drivers or which bars should be totals, so check the source data and set the opening and ending bars as totals yourself.

Should revenue decreases be entered as negative numbers?
Yes. Enter decreases such as churn or contraction as negative values so they reduce the running total. The category name alone does not determine whether Excel treats a movement as an increase or decrease.

Why does my ending revenue not equal the sum of the bridge?
First calculate the opening revenue plus every signed change. Then check for omitted or duplicated categories, inconsistent periods or units, and rounding. If the bridge still differs from the reported close, show the difference transparently and investigate it rather than disguising it with an unsupported adjustment.

Can I show monthly revenue in a waterfall chart?
You can, but a waterfall is most useful for explaining changes from one defined starting point to one ending point. For a sequence of monthly totals, a line or column chart is usually clearer. A monthly waterfall can work when each month is deliberately presented as a contribution to a cumulative period total, provided that interpretation is explained.

Can I use the chart for bookings or recurring revenue?
Yes, if the measure is defined consistently and the bridge components reconcile to it. Label the chart as bookings, ARR, or another specific measure rather than calling it revenue when it represents something different. Those metrics can have different recognition and calculation rules.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.