PowerPoint waterfall chart

To create a waterfall chart in PowerPoint, go to Insert > Chart > Waterfall and enter your starting value, intermediate changes, and final result into the spreadsheet that opens. Then, click once on the final total column and select "Set as Total" from the right-click menu to seat the column firmly on the baseline.

Waterfall charts (also known as bridge charts) show step-by-step how an initial value arrives at a final result across time or line items through positive and negative inputs. They are far more effective than standard column charts for income statements, budget variances, and multi-step cost analyses that might otherwise cause confusion.

Prerequisites and Data Logic

The built-in waterfall chart type in PowerPoint is natively supported in Microsoft 365, PowerPoint 2024, PowerPoint 2021, PowerPoint 2019, and PowerPoint 2016 (Windows and macOS). To verify that your version includes this feature, you can check the list of chart types located on the Insert tab of the ribbon.

For the waterfall chart to calculate correctly, your data structure must be ordered according to a specific logic:

The first row must represent the starting value (for example, Beginning Balance).

Intermediate rows must contain the positive amounts to be added to the cumulative total or negative amounts (with a minus sign) to be subtracted.

Subtotal or grand total rows must appear as the final net amount, not as a formula-summed value. Until you define it as a total, the chart engine will attempt to treat this value as an additional increase or decrease.

If you have different data visualization requirements, you can also review the steps to adjust the scale in a PowerPoint bar chart or reverse the order in a PowerPoint bar chart depending on what the presentation needs to accomplish.

Steps to Create a Waterfall Chart in PowerPoint

1. Select a blank slide or one appropriate for your content.

1. Go to the Insert tab on the ribbon, click the Chart icon, select Waterfall from the All Charts tab, and click OK. As noted in the Microsoft Support: Create a waterfall chart documentation, a waterfall chart can be inserted directly from the relevant chart icon in the Insert menu or from the All Charts tab.

1. Enter your data into the small spreadsheet window that opens alongside the chart. Enter category names in the first column and numerical values in the second column.

1. Close the spreadsheet window after completing your data entry. Your chart will appear on the slide. You can customize the look of the chart using the Chart Design (or Design) and Format tabs on the ribbon. If these tabs are not visible, simply click anywhere on the chart.

Anchoring Total and Subtotal Columns

By default, the chart engine plots all values as floating columns. This causes the grand total column at the end of the chart, such as "Net Profit," to hang suspended in midair and look as though it doubles the cumulative value.

To fix this issue:

Click the chart once to select the entire series, then click once more on only the column you want to designate as a total (for example, "Net Income") to select that single data point.

Right-click the selected column and open the "Format Data Point" task pane.

Check the "Set as total" box located here. Alternatively, you can select the "Set as Total" command directly from the shortcut menu that appears when you right-click the data point. This action brings the bottom edge of the column down to the horizontal axis (the zero line) and prevents it from floating. If you wish to make the column floating again, you must clear the check mark from the "Set as total" box.

If you have multiple subtotals (such as Operating Profit or Gross Profit), repeat this same process separately for each subtotal column.

Managing Connector Lines and Colors

The horizontal connector lines between columns in a waterfall chart show the flow of data by connecting the end level of the previous column to the start level of the next column.

To hide or display connector lines again, right-click the data series, open the "Format Data Series" pane, and either uncheck or check the "Show connector lines" box according to your preference.

In terms of colors, the waterfall chart legend groups three different types of data points: Increase, Decrease, and Total. As explained in the Microsoft Support: Available chart types in Office guide, built-in chart types across Office applications offer structured layouts that make data series easier to analyze. Selecting a group from the legend highlights all columns belonging to that group in the chart.

Concrete Example Scenario: Annual Budget Bridge

Below is a sample dataset representing a fictional departmental budget bridge:

Category: Starting Budget | Value (TL): 500000 Category: Additional Project Revenue | Value (TL): 120000 Category: License Costs | Value (TL): -45000 Category: New Personnel Expense | Value (TL): -85000 Category: Hardware Savings | Value (TL): 30000 Category: Closing Balance | Value (TL): 520000

Implementation Step: Enter the values from the table into the spreadsheet opened by PowerPoint. In the chart, the Closing Balance column will initially be positioned as a floating increase starting upwards from the 520000 level. When you click the Closing Balance column individually and select "Set as Total" from the right-click menu, the column will anchor at the 520000 level starting from zero on the baseline, correctly establishing the bridge logic alongside the intermediate changes.

Common Issues and Solutions

The Set as Total option does not appear: Usually, clicking the chart once selects the entire data series, and right-clicking displays "Format Data Series" instead of "Format Data Point" in the menu. Click the column just once more to verify that selection handles appear around only a single data point.

Negative values drop below zero: If the cumulative total of positive and negative changes results in a negative balance larger than the initial value, the axis expands below zero. This is an expected mathematical outcome; however, if it stems from a sign error in the data, check the minus signs in the spreadsheet.

The chart type is not listed: In older versions of PowerPoint or certain editions of the web interface, the built-in waterfall chart may not be directly supported. In this case, you should verify whether your version of Office supports waterfall charts or consider creating the chart in the Excel desktop application and copying it onto the slide.

Verification Checklist

Complete these checks before sharing your presentation:

Do the starting and final total columns begin from zero on the horizontal axis?

Has it been verified that all deduction items are entered with a minus (-) sign in the data table?

Are subtotals and grand totals anchored to the horizontal axis using "Set as Total"?

Have connector lines been checked to ensure they clearly show data flow, and toggled on or off as preferred?

Has it been confirmed via the Chart Design or Format tabs that color groupings (Increase, Decrease, Total) are clear and legible?

Frequently Asked Questions

Is it possible to link a waterfall chart created in Excel to PowerPoint?

Yes. When copying a waterfall chart prepared in Excel to the clipboard and pasting it onto a PowerPoint slide, you can choose either "Link Data & Use Destination Theme" or "Link Data & Keep Source Formatting" from the paste options. This way, as data changes in the Excel workbook, the waterfall chart in PowerPoint updates accordingly.

Where can column spacing be adjusted in a waterfall chart?

Right-click any column in the chart and open the "Format Data Series" pane from the menu. Under the Series Options icon, you can narrow or widen the distance between columns by adjusting the "Gap Width" setting.