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
In this article
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
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
- In Excel, on the Power-user tab, click Create Waterfall chart.
- In the dialog box, select your data, including the row and column headers.
- 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
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
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
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
Feedback sent
We appreciate your effort and will try to fix the article