Excel Online Waterfall Chart: How to Set a Bar as Total

In Excel for the web, select the individual waterfall column and check its right-click menu for Set as Total. If that command is missing, the web version you are using does not expose the setting: choose Open in Desktop App and set the point as a total in desktop Excel instead.

What setting a bar as a total does

A waterfall chart shows how a starting value changes through a sequence of increases and decreases. Ordinary columns represent changes: they float between the previous running value and the new one. A total column works differently. It starts at the chart’s baseline and represents a complete value at that stage, rather than another change to add to the running total.

This distinction matters for opening balances, subtotals, and final results. Suppose a report starts at 100, adds 30, subtracts 20, and then displays a subtotal of 110. The subtotal is already the accumulated result of the earlier movements. If Excel treats 110 as another increase, it will calculate the next step from 220, which is wrong. Marking the subtotal as a total tells the chart to show a full-height column at 110 and continue the running sequence from that value.

Setting a point as a total changes how the chart interprets that point; it does not change the number in the worksheet. It is a chart-format setting, so the source value remains available for calculations and other uses.

Try the setting in Excel for the web

Start with a waterfall chart that is already based on the values you want to show. Then try to select the relevant column itself, not just the chart area or the entire series. In the browser, the selection can take a couple of clicks:

Click the chart once. This selects the chart.
Click the target column once to select the series, then click that same column again to select the individual data point. Avoid double-clicking rapidly; the goal is to select the point, not open another interface.
Right-click the selected column and look for Set as Total in the context menu.
If the command appears, choose it. Check that the column now begins at the baseline and that the following change continues from the intended running value.

On a Mac, use a secondary click, such as a two-finger click on a trackpad, to open the context menu. The exact menu and available chart commands can vary with the Excel for the web interface and the workbook. If you can select the bar but do not see Set as Total, try the desktop fallback below rather than changing the source number to force the appearance.

Use desktop Excel when the command is missing

Excel for the web does not always expose every point-level chart-formatting command available in the desktop application. If Set as Total is absent, open the workbook in the desktop version of Excel for Microsoft 365. In Excel for Windows, select the chart, select the specific column, right-click it, and choose Set as Total. The menu applies to the selected data point, so make sure you have not selected the whole series. On Mac, select the point and use a secondary click to look for the same command.

After making the change, save the workbook. If it is stored in OneDrive or SharePoint, the saved chart setting should be available when you return to the web version, though the web interface may still offer fewer editing controls. If the workbook is not saved to a cloud location, save it in a place you can reopen from the browser before expecting your changes to appear online.

Do not confuse this with changing a chart title, color, or axis. Those edits affect presentation, while Set as Total changes the role of a particular waterfall point. Replacing a value with zero or manually adjusting it can make the picture look plausible while leaving the underlying data meaning incorrect.

Prepare the data for a clear waterfall

A well-structured source list makes it easier to identify which bars are changes and which are totals. Use one column for category labels and another for chart values. List the categories in the order they should appear, and enter changes as positive or negative amounts. For example:

Opening balance: 100
New sales: 30
Refunds: -20
Subtotal: 110
Operating costs: -10
Closing balance: 100

The arithmetic is 100 + 30 – 20 = 110, then 110 – 10 = 100. The subtotal and closing balance are complete values, not additional movements. Mark those points as totals if the chart needs to show them as full columns from the baseline. In this example, the chart should show the opening value at 100, the sales and refunds as floating changes, the subtotal at 110, costs as a downward change, and the closing value at 100.

For an ordinary waterfall chart, positive changes usually move the running value upward and negative changes move it downward. Use the sign convention consistently. If costs are entered as positive numbers, Excel will show them as increases unless the chart’s data or setup accounts for that direction. A total should contain the cumulative value at that point, not merely the amount of the latest change.

Why a total may look wrong

A total bar that floats instead of starting from the baseline is commonly still being treated as a change. Select that individual point and apply Set as Total. Conversely, if a bar unexpectedly spans from the baseline, check whether it was marked as a total when it should represent a movement. The setting is per data point, so a chart can contain both total bars and ordinary increase or decrease bars.

Another frequent problem is choosing the wrong point. A click on a column may select the entire series; applying a command at that level can be unavailable or affect a different selection than intended. Click the same column again to target the individual point, and verify its category label before changing it. If the chart is small or categories are close together, temporarily enlarge it or select a different point and then return to the intended one.

Check the source values as well. In the example above, the subtotal must be 110. If it is entered as 10, marking it as a total makes a total column at 10; the chart cannot infer that the intended subtotal was 110. Likewise, adding a subtotal row as though it were another movement can inflate the running result. Make the source data represent the story you mean to tell, then use the chart setting to identify totals.

Creating and checking the chart

If you have not created the chart yet, arrange the category names and values in adjacent columns, select the data range, and insert a Waterfall chart from Excel’s chart options. The exact location of the chart button can change as the web interface evolves; look under the Insert tab for chart options and choose Waterfall if it is offered. Then inspect the bars in sequence and mark opening, subtotal, and closing values as totals where appropriate.

Validate the result with a simple running calculation outside the chart or by checking the arithmetic in the source list. For each movement, add its signed value to the preceding running result. At a subtotal, compare the entered subtotal with that running result. After the subtotal, the next movement should continue from the subtotal rather than from an accidentally added subtotal-plus-running-value. This check catches a common visual trap: a chart may look orderly even when the source values mix balances and changes.

Also check the category labels, especially if there are several similar rows such as monthly totals or department subtotals. A viewer should be able to tell which bars are movements and which are checkpoints. Consider using clear names such as Opening balance, Q1 subtotal, and Closing balance instead of labels such as Total 1 or Result.

When to use a different chart or layout

A waterfall chart is useful when the main point is how a value changes from a start to an end. It is less suitable when readers need to compare many unrelated categories, or when every column should share the same baseline and show an independent value. A standard clustered column chart is often clearer for side-by-side comparisons; a line chart can be better for a continuous time trend.

If your Excel for the web account will not let you set totals and you cannot open the desktop application, you can still show the underlying sequence in a labeled table. Another option is to prepare the waterfall chart in desktop Excel and use the web version mainly to view or make supported edits. Avoid disguising a normal column chart as a waterfall by inserting blank or artificial values unless you can maintain the data carefully: that approach is more fragile when categories or amounts change.

Frequently Asked Questions

Can I set a waterfall bar as a total in Excel for the web?
Try selecting the individual bar and checking its right-click menu for Set as Total. If the command is not available in your web interface, open the workbook in desktop Excel and apply the setting there.

Why can’t I see Set as Total?
You may have selected the chart or whole data series rather than one point, or your Excel for the web version may not offer that chart command. Select the bar itself first; if the option remains missing, use desktop Excel.

Does setting a point as a total change my worksheet value?
No. It changes how that point is drawn in the waterfall chart. The number in the worksheet stays the same.

Should I mark the first and last bars as totals?
Usually, yes, when they represent complete opening and ending balances. Mark intermediate checkpoints as totals too when they represent cumulative subtotals rather than new changes.

Can I mark a negative value as a total?
A total represents a complete level, which can be negative as well as positive. The source value should be the actual cumulative level; do not enter a negative movement as a total simply because it decreases the running result.

Will the setting remain when I return to Excel for the web?
It should remain after the desktop workbook is saved, including when the file is stored in OneDrive or SharePoint. If it does not appear as expected, reopen the saved workbook and confirm the chart point and its source value.

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.