Excel Waterfall Chart Not Showing Total? Fix It

If an Excel waterfall chart is not showing a total, select the bar that should represent the total, right-click it, and choose Set as Total. Excel otherwise treats that data point as a change that adds to or subtracts from the running balance, so the bar may float instead of starting at the chart baseline.

What a total means in a waterfall chart

A waterfall chart explains how a starting amount changes through a sequence of increases and decreases to reach an ending amount. The individual changes are usually floating columns: each begins at the previous running balance and extends up or down by the size of that change. A total is different. It represents a complete balance, so its column should run from the baseline to the value of that balance.

For example, imagine a project begins at 100, receives a 30 increase, has a 20 decrease, and ends at 110. The changes reconcile because 100 + 30 – 20 = 110. The opening 100 and ending 110 are balances, while +30 and -20 are movements. If Excel interprets the ending 110 as another increase, it adds that amount to the running balance and the chart tells the wrong visual story.

A chart can still display a column and its label while failing to show it as a total. The key distinction is not whether a number appears, but whether the point is classified as a total or as a change. A total is anchored to the baseline; an increase or decrease floats at the current cumulative level.

Set a bar as a total in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, the total setting is applied to an individual data point in the chart. It is not a number format or a worksheet formula, and changing the source value alone does not tell Excel that the value is a subtotal.

Click the waterfall chart once to select it.
Click the specific column that should be a total. If the first click selects the whole series, click that same column again to select just the data point.
Right-click the selected column and choose Set as Total.
Check that the column now starts at the baseline and reaches the value shown by its label or axis position.
Repeat for any other opening balance, subtotal, or ending balance that should be shown as a total.

Be careful to select the bar itself rather than the chart background, axis, legend, or whole series. Those selections show different context-menu options. If the menu does not contain Set as Total, click the chart and then click the intended column again; Excel needs a single point selected for this command.

On Mac, the same general chart-point setting is available in desktop Excel, although the context menu and formatting controls can look different from Windows. In Excel for the web, chart editing controls can also differ by account and release. If the point-level command is unavailable in the interface you are using, open the workbook in the Excel desktop app and apply the setting there.

Check the source data and running balance

Before changing chart formatting, verify that the data describes the story you intend to show. A simple layout has one category column and one value column: the category identifies each step, and the value is either a complete balance or a signed change. For instance, categories might be Opening balance, New sales, Returns, and Closing balance. Values could be 100, 30, -20, and 110.

In that example, the chart should show Opening balance and Closing balance as totals, while New sales and Returns remain changes. The arithmetic reconciles: the starting value of 100 plus 30 in sales, less 20 in returns, gives 110. If the closing value were entered as 10, the chart might still draw a bar, but the data would not describe the intended ending balance.

Keep the source values in the order that the changes occur. A waterfall chart uses the sequence to calculate the visual running balance; sorting the categories alphabetically or by value can therefore change the story. Also check for blank rows, unintended text in the value column, and duplicate or unclear category labels. These issues do not always cause a missing total directly, but they can make the displayed steps difficult to interpret or select.

Use positive values for increases and negative values for decreases when the steps are changes.
Use the full balance, not just the difference, for a point intended to be a total.
Label subtotal rows clearly so readers can distinguish a balance from a change.
Check that the opening and ending values reconcile with the intervening changes.

Do not replace a subtotal with a calculated difference just to make the bar appear at the baseline. For example, if a subtotal is 110, entering 10 may represent the change from 100, but it does not represent the subtotal itself. Set the 110 point as a total instead, and keep the change and total concepts separate.

Why the total option may appear missing

The most common cause is selecting the wrong chart object. A single click on a column series may select every column; the command for one point is only relevant after selecting the intended column itself. Click the bar once, then click it again if needed, and look for selection handles on only that point before opening the context menu.

Other causes are less obvious. The chart might not be a native Excel waterfall chart, or the selected object might be a shape or picture of a chart. A pasted image cannot be edited as chart data. Another possibility is that the point is already set as a total; selecting it again may show Reset to Total or a similar reset command rather than the original option. The exact wording can vary with the selected state and Excel interface.

If the chart was copied from another workbook, converted from a different chart type, or substantially edited, make sure Excel still recognizes it as a waterfall chart. Select it and inspect the chart type from the Chart Design tab. If it is a different chart type, choosing a waterfall chart may be necessary before the point-level total control becomes available. Changing chart type can affect formatting, so check the labels, colors, and data selection afterward.

Finally, confirm that the intended column is actually part of the chart. Select the chart and open Chart Design > Select Data to review the chart’s categories and values. If the row is outside the selected source range, it cannot be formatted as a chart point until the range includes it.

Why a total can still look wrong

A correctly designated total can seem missing when it is too short, hidden, or visually confused with a change. Check the vertical axis scale first. If the values are very large, a small total or a small difference between nearby values may be hard to distinguish. Axis bounds and units affect how the chart reads, even though they do not change the underlying data.

Look for overlapping labels, a narrow chart, or a column color that is difficult to distinguish from the increase and decrease colors. Excel commonly distinguishes totals, increases, and decreases with separate formatting, but color choices can be changed. Click the point and use the formatting controls if you need a clearer fill or border. Do not rely on color alone: category labels and a clear title help explain which bars are balances.

Connector lines can also affect the impression of a total. They connect the running levels between changes; they do not convert a change into a subtotal. If connectors make the chart busy, select the chart and use Chart Design > Add Chart Element to review available chart elements and connector-line choices. The exact choices depend on chart type and Excel version. Removing a connector may make the presentation cleaner, but it does not fix a point that is classified incorrectly.

Another common source of confusion is a baseline that is not zero or is difficult to see. The total column is anchored to the chart baseline, but a cropped axis can make the column appear to start somewhere unexpected. Review the axis scale and compare the bar with the plotted zero level before concluding that the total setting failed.

Totals, subtotals, and ordinary changes

In everyday use, people may call any intermediate balance a subtotal. In a waterfall chart, the practical question is whether that point should be displayed as a complete balance or as a movement from the previous balance. A quarterly subtotal, for example, usually represents a balance and should be set as a total. A monthly expense is usually a negative movement and should remain a decrease.

Consider a yearly report with an opening balance of 500, first-quarter change of +80, first-quarter subtotal of 580, second-quarter change of -25, and ending balance of 555. The +80 and -25 points are changes. The 580 subtotal and 555 ending balance are complete balances, so mark those points as totals. The final arithmetic is 500 + 80 – 25 = 555; the subtotal is a checkpoint, not an additional +580 movement.

This distinction prevents a frequent error: adding every displayed value as if it were a change. A chart’s total point resets the visual running position to the value of that balance; it is not another movement layered onto the prior one. When preparing source data, make the category names explicit, such as “Q1 subtotal,” rather than using a vague label like “Q1.”

When to rebuild or choose another chart

If a waterfall chart becomes difficult to repair, rebuilding it from a clean category-and-value range can be faster than repeatedly adjusting individual points. Select the intended source data, then use Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall in Excel for Microsoft 365 on Windows. After insertion, set the balance rows as totals again and verify the resulting running sequence. Recreating the chart does not guarantee that every subtotal will be identified automatically.

A waterfall chart is useful when the purpose is to explain how a beginning value moves to an ending value. If the task is instead to compare independent values across categories, a clustered column chart may be clearer. If the goal is to show a trend over time, a line chart may be more appropriate. In either case, select the chart according to the question the reader needs answered, not simply because the source data happens to contain positive and negative numbers.

For a report with multiple separate scenarios, consider whether one chart with a long sequence is still readable. Separate charts or a carefully designed comparison chart may make the differences easier to interpret. A standard waterfall chart is primarily designed around a sequence of changes and balances, so it is not a general replacement for every chart with plus and minus values.

Frequently Asked Questions

How do I make the last bar a total in an Excel waterfall chart?
Select the last bar as an individual data point, right-click it, and choose Set as Total. Check that the source value is the complete ending balance, not just the final period’s change.

Why is my waterfall total floating instead of starting at zero?
Excel is likely treating that point as an increase or decrease. Select the individual bar and choose Set as Total. If it still looks unusual, inspect the vertical axis baseline and scale.

Can I show more than one total in a waterfall chart?
Yes. You can mark multiple data points as totals, such as the opening balance, intermediate subtotals, and closing balance. Set each applicable point individually and keep ordinary increases and decreases as changes.

Does Excel calculate the subtotal automatically?
No. Excel uses the supplied values and the point’s total-or-change setting to draw the chart. It does not know which rows are intended as business subtotals unless you provide the correct balance values and mark those points as totals.

Why is Set as Total missing from the right-click menu?
You may have selected the chart area or the whole series rather than one column, or the object may not be an editable waterfall chart. Select a single bar and try again; if it is a picture or another chart type, use the original chart or recreate it as a waterfall chart.

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.