EBITDA Waterfall Chart in Excel: Build It Step by Step

To make an EBITDA waterfall chart in Excel, list opening EBITDA, each positive or negative driver, and closing EBITDA in two columns; select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Right-click the opening and closing columns and choose Set as Total so Excel displays them as full bars. The result is a visual bridge showing how the business moved from one EBITDA figure to another.

What an EBITDA waterfall chart shows

An EBITDA waterfall, also called an EBITDA bridge, explains the change between a starting and ending EBITDA amount. The first bar is the starting point, often last year’s or last quarter’s EBITDA. The floating bars in between show individual increases and decreases. The final bar is the ending EBITDA after all the listed changes.

EBITDA means earnings before interest, taxes, depreciation, and amortization. It is a performance measure, not a direct measure of cash flow, and companies may define or adjust it differently. A bridge is only as comparable as the EBITDA figures and driver definitions behind it. If the starting figure is adjusted EBITDA, the ending figure should generally use a consistent definition, with adjustments disclosed clearly.

For example, a company might explain a rise in EBITDA through higher sales volume and pricing, partly offset by materials, wages, and marketing costs. The chart makes the direction and relative size of those drivers easier to scan than a pair of totals alone. It does not, by itself, prove why a change occurred; that explanation depends on the underlying analysis.

Prepare a clear, comparable bridge

Before opening the chart menu, decide what the comparison is meant to explain: a year-over-year change, a quarter-to-quarter movement, or a budget-to-actual variance. Use comparable periods and consistent accounting definitions. A bridge that mixes reported EBITDA at the start with adjusted EBITDA at the end can be misleading unless the adjustments are separately shown and explained.

Choose driver categories that are both meaningful and supported by the company’s data. Common categories include volume, price, product or customer mix, input costs, labor, operating expenses, foreign exchange, acquisitions, and one-off items. Avoid using a broad label such as other for a large unexplained amount. If a residual is necessary, identify what it contains and why it cannot be assigned more precisely.

Keep the same units: use dollars throughout, or show all values in millions and label the chart accordingly.
Define the sign convention: increases to EBITDA are positive; reductions are negative.
Separate revenue from profit impact: a revenue increase is not automatically an equal EBITDA increase. Show the estimated EBITDA contribution after relevant variable costs.
Document unusual items: make clear whether restructuring, acquisition, or other adjustments are included.

Set up the Excel data

For Microsoft Excel for Microsoft 365 on Windows, enter categories in column A and the corresponding amounts in column B. Put the opening amount first, each movement on its own row, and the closing amount last. The amounts below are illustrative and in millions of dollars.

A2: Opening EBITDA; B2: 12.0
A3: Revenue and mix; B3: 2.4
A4: Price; B4: 0.8
A5: Materials; B5: -1.1
A6: Labor; B6: -0.6
A7: Marketing; B7: -0.4
A8: Other operating expenses; B8: 0.3
A9: Closing EBITDA; B9: calculate the total

The bridge arithmetic is 12.0 + 2.4 + 0.8 − 1.1 − 0.6 − 0.4 + 0.3 = 13.4, so closing EBITDA is 13.4 million. With the opening amount in B2 and all movements in B3:B8, enter this formula in B9: =SUM(B2:B8). The formula returns 13.4. Keep the closing amount in the same units as the other rows; do not enter 13,400,000 if the rest of the chart is expressed in millions.

Use one row per driver rather than combining unrelated explanations. If you have several cost categories, separate them when the distinctions help the reader understand the result. On the other hand, too many tiny rows make a chart hard to read. Group immaterial items transparently, and retain the detailed calculation elsewhere in the workbook.

Insert and configure the waterfall chart

Select A1:B9, including the category names and amounts. If your headers are not in row 1, select the full range that contains both columns and all bridge rows.
On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.
Excel creates a chart from the selected values. The first and final rows may initially appear as floating change bars, so identify them as totals.
Right-click the Opening EBITDA bar and choose Set as Total. Repeat for the Closing EBITDA bar.
Check that the intermediate bars rise or fall from the running subtotal and that the final total agrees with the calculation in the worksheet.

Setting the first and last bars as totals is important: Excel cannot reliably infer from the numbers alone that these rows are fixed endpoints rather than changes. The Set as Total command applies to the selected data point. If you edit the bridge later, confirm that both endpoint bars still behave as totals and that any added categories are included in the chart’s source data.

In current Microsoft 365 for Mac, waterfall charts are available as well, though ribbon placement and contextual menus can differ from Windows. Look under the Insert tab for the Waterfall chart option and use the selected point’s context menu to set totals. Excel for the web may offer a different set of chart-editing controls, so use the desktop app if a formatting or data-point command is unavailable.

Format the chart for quick reading

A useful waterfall should make the endpoints, direction, and scale obvious without making the viewer decode decorative effects. Give it a specific title, such as EBITDA change, 2025 actual to 2026 actual, and note the unit in the title or axis label. If the numbers are in millions, say so; a chart with values like 12.0 and 13.4 can otherwise be mistaken for dollars rather than millions.

Use distinct, consistent colors for increases, decreases, and totals. Excel’s default colors can be a starting point, but check that the contrast remains clear and that the chart is still understandable if printed in grayscale or viewed by someone with color-vision differences. Select an individual bar and use the formatting pane to adjust its fill when you need to emphasize a category. Avoid using color alone to communicate a critical distinction; labels and signs should support it.

To show amounts on the bars, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a suitable position such as Outside End. Check the labels for overlap, especially with many categories or negative values. Format the source cells or chart axis with an appropriate number format and sensible decimal places. Remove unnecessary gridlines or a redundant legend, but retain an axis scale that does not exaggerate small differences.

Read the bridge and check the math

Read from left to right: start with the opening total, follow each upward or downward movement, and finish at the closing total. In the example, positive revenue and pricing contributions add 3.2 million; the three negative movements reduce EBITDA by 2.1 million; other operating expenses add 0.3 million. The net increase is 1.4 million, taking EBITDA from 12.0 million to 13.4 million.

Reconcile the chart to the source calculation before sharing it. The sum of all movements should equal closing EBITDA minus opening EBITDA. In this example, the movements total 1.4 million, which matches 13.4 minus 12.0. If they do not reconcile, check for omitted categories, duplicated rows, reversed signs, rounding, or a closing formula that excludes a movement. A waterfall can look polished while still presenting an incorrect bridge.

Also distinguish a driver from a metric that merely correlates with the change. For instance, sales rose by 2.4 million in revenue, but that does not establish a 2.4 million EBITDA contribution. The bridge should use a supportable estimate of the profit effect after variable costs, discounts, and other relevant impacts. Explain material assumptions in a note or supporting schedule.

Common Excel problems and fixes

The opening or closing bar floats: right-click that individual bar and choose Set as Total. Repeat for both endpoints.
A bar moves in the wrong direction: check the sign in the source data. Increases should be positive and decreases negative under the convention used here.
The closing bar does not match the calculated total: make sure the chart includes every movement exactly once and the closing value uses the same units and definition as the opening value.
Category labels are missing or numbers appear as labels: select the intended two-column range, with category names beside values, then recreate or edit the chart’s data selection.
The chart is hard to follow: reduce the number of categories, use clearer labels, and group only small, related items. Do not hide a material variance in an unexplained residual.
Data labels collide: remove some labels, widen the chart, or use a supporting table for exact values. Not every bar needs a label if the category names and scale are clear.

When to use another chart

A waterfall is a strong choice when the main question is how a starting figure changes into an ending figure through a sequence of additive drivers. It is less suitable when the goal is to compare many companies or periods side by side. For those comparisons, a clustered column chart, line chart, or table may make patterns easier to compare. A waterfall also becomes crowded when there are dozens of small drivers; a summarized bridge with a detailed schedule beneath it may work better.

Do not confuse an EBITDA bridge with a cash-flow waterfall. EBITDA excludes interest, taxes, depreciation, and amortization, while cash flow can also reflect working capital, capital expenditure, debt payments, and other cash movements. A chart titled EBITDA should not be presented as cash generated unless it has been separately reconciled to a cash measure. Similarly, adding back an expense for an adjusted EBITDA bridge is a choice that needs a consistent definition and transparent explanation, not merely a chart-formatting decision.

Frequently Asked Questions

Does Excel have a built-in waterfall chart?

Yes. Microsoft 365 for Windows includes a Waterfall chart in the Insert tab’s chart options. After inserting it, set the opening and closing bars as totals so they display as full-height endpoint columns.

How do I make the first and last bars totals?

Right-click the first bar, choose Set as Total, and repeat for the last bar. If the command does not appear, make sure you selected a single data point rather than the whole chart or series.

Can I make an EBITDA waterfall chart without a formula?

Yes. You can type the opening value, each movement, and the closing value directly into the data table. A closing-total formula such as the SUM example above helps keep the endpoint in step with changes to the bridge, but it is optional.

Why does my waterfall chart show a negative value as a positive bar?

Check that the source cell contains a negative number, not a positive number with a minus sign included as text. Also verify the chart uses the intended data range. Under the convention in this guide, costs that reduce EBITDA are negative values.

Should revenue growth equal the revenue bar in an EBITDA bridge?

Not necessarily. Revenue growth is not the same as EBITDA growth: variable expenses and mix can change the profit contribution. Use a defensible estimate of the EBITDA impact and explain the calculation or assumptions behind a material driver.

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.