[Legacy] Waterfall charts

Modified on Sat, 14 Nov at 7:08 PM

The Power-user Waterfall chart is a legacy feature of the Power-user add-in for Excel that creates a waterfall chart (also called bridge chart) from your data, with one or several series, built out of shapes. A waterfall chart shows how positive and negative items add up from a starting value to a total, which makes it one of the most popular charts in finance.

Legacy feature: more dynamic, robust and flexible waterfall charts, including stacked waterfalls, can now be inserted from the Charts tab of the Power-user Library. See Library - Charts.

In short

  • Where: Create Waterfall chart in the Power-user tab of Excel
  • Your data: one column per item, one row per series
  • Edit: right-click the chart and click Edit Waterfall chart to set totals, connectors, colors and labels
  • Recommended today: the waterfall and stacked waterfall charts of the Library

What is a waterfall chart?

A waterfall chart shows how a total breaks down into items that are added or subtracted. In this example, the total at the end of the year is explained by each monthly variation: increases in green, decreases in red, and the totals at the beginning and end of the year in blue.

Waterfall chart in Excel: monthly variations from the beginning to the end of the year

Waterfall chart in Excel: monthly variations from the beginning to the end of the year

Typical uses:

  • showing all the aggregates of a profit and loss statement;
  • running a gap analysis: what impacted a metric positively or negatively, for example activity in year N explained by year N-1, minus churn, plus new clients.

Good to know: Office 2016 and later include a built-in waterfall chart. The Power-user waterfall also works with older versions of Office and can show several series on the same chart, for example two products.

How to create a waterfall chart in Excel

Organize your data with one column per item of the waterfall. A typical waterfall has a single series: a header row and one row of values. For several series, add one row per series.

Data source of a waterfall chart: one column per item, one row per series

Data source of a waterfall chart: one column per item, one row per series

  1. In Excel, on the Power-user tab, click Create Waterfall chart.
  2. In the dialog box, select your data, including the row and column headers.
  3. Click OK. The waterfall chart is created automatically.

You can then define totals to make the waterfall ascending, descending or both, show one series or stack several, let the chart go below the axis, and change its colors, borders and labels.

How to edit a waterfall chart

Right-click the chart and click Edit Waterfall chart. The edit pane opens.

Chart Options

In the Chart Options tab, you can:

  • add, remove or edit the chart title;
  • change the border color;
  • show or hide the totals of the categories or labels;
  • set the number of decimals for values and percentages;
  • add or remove connectors.

Chart Options tab of the waterfall chart edit pane

Chart Options tab of the waterfall chart edit pane

Tip: the labels use the number format of the cells of your data source. To change their format, format the source cells and update the chart.

Series Options

In the Series Options tab, select a series of the chart, then:

  • change the fill color of this series only;
  • change the color, font size and other settings of its labels;
  • set a value as a Total: its bar starts from the horizontal axis instead of from the previous value.

Series Options tab of the waterfall chart edit pane

Series Options tab of the waterfall chart edit pane

Waterfall charts in PowerPoint

To add a waterfall or a stacked waterfall chart directly to a slide, insert it from the Charts tab of the Power-user Library. See Library - Charts.

Stacked waterfall chart in PowerPoint: revenue bridge by product line

Stacked waterfall chart in PowerPoint: revenue bridge by product line

Frequently asked questions about waterfall charts

What is a waterfall chart used for?

A waterfall chart, or bridge chart, shows how a starting value becomes a final value through positive and negative items. It is used for profit and loss statements, budget bridges and gap analyses.

How do I make a waterfall chart with several series in Excel?

The built-in Excel waterfall shows one series. With the Power-user Create Waterfall chart, add one row per series in your data to stack several series on the same chart. In PowerPoint, use the stacked waterfall of the Power-user Library.

How do I set a bar as a total in a waterfall chart?

In the Power-user waterfall edit pane, open the Series Options tab, select the value and set it as a Total: its bar starts from the horizontal axis.

Can I make a waterfall chart in older versions of Excel?

Yes. The built-in waterfall chart only exists since Office 2016; the Power-user Create Waterfall chart also works with older versions of Excel.

How do I make a waterfall chart in PowerPoint?

Insert a waterfall or stacked waterfall chart from the Charts tab of the Power-user Library in PowerPoint. The Create Waterfall chart button of the Power-user ribbon is only available in Excel.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article