Excel Waterfall Chart Total Column: How to Add One

To make a column a total in an Excel waterfall chart, select that individual column, right-click it, and choose Set as Total. Excel then anchors the column to the chart’s baseline instead of treating its value as another increase or decrease in the running balance.

What a total column means in a waterfall chart

A waterfall chart shows how a starting amount changes as increases and decreases accumulate. Its floating columns represent changes from one running value to the next: positive values generally rise from the previous balance, and negative values fall from it. A total column is different. It represents a complete amount, so it begins at the chart’s baseline and reaches the stated total.

This distinction matters because a number in the source data does not automatically tell Excel whether it is a change or a final balance. For instance, an ending cash balance of 115 is a total of 115, not an additional increase of 115 after the preceding changes. If Excel treats it as a change, the last column floats upward from the existing balance and the chart suggests an incorrect result.

Waterfall charts commonly use total columns for the opening value, closing value, and intermediate subtotals. They are useful for explaining how a result was reached, rather than simply comparing separate category values. Examples include a profit bridge, a cash movement report, a project budget, or a headcount change summary.

How Excel treats increases, decreases, and totals

Excel calculates a running position through the sequence of data points. A positive change adds to that position; a negative change subtracts from it. A regular change column therefore floats between the prior and new positions. Marking a point as a total tells Excel to display that point as an absolute amount from the baseline and to use it as the reference position for subsequent changes.

That last detail is useful for charts with a subtotal partway through. Suppose an opening amount is 100, revenue adds 45, and expenses subtract 20. The running position is 125 after expenses. A subtotal column with a value of 125 can be marked as a total; a later expense of 10 then takes the running position to 115. The subtotal is not an extra 125 added to the earlier movements.

Marking a point as a total changes how Excel draws that point, not the underlying value in the worksheet. The chart does not calculate a subtotal for you merely because you set a column as total. Enter the correct total in the source data, or calculate it in the worksheet, and then set the corresponding chart point as a total.

Set a column as a total in Excel for Windows

In Excel for Microsoft 365 on Windows, first create a waterfall chart from a category-and-value range. Select the range, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Once the chart appears, mark the point or points that represent totals:

Click the chart once, then click the specific column you want to change. The second click selects that data point rather than the whole series. Take care not to double-click so quickly that Excel opens a formatting pane instead.
Right-click the selected column and choose Set as Total from the context menu.
Repeat for each opening balance, closing balance, or subtotal that should be anchored to the baseline.
Check the chart against the source figures. Confirm that the total columns show the intended amounts and that the changes after a subtotal continue from the correct running position.

You can also select the point and open Format Data Point from its context menu. In the formatting pane, enable Set as total if that option is shown. The wording or pane layout can vary slightly with Excel updates, but the point-level setting is the important part. A chart-wide series selection is not the same as selecting an individual column.

To add labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a suitable position. Labels make totals easier to interpret, especially when several floating changes are close together. Review label placement after adding them: long category names or small columns can cause labels to overlap.

A worked example: a cash movement chart

Imagine a simple cash bridge with these source values:

Opening cash: 100
Customer receipts: 45
Supplier payments: -20
Tax payment: -10
Closing cash: 115

The movements produce a closing balance of 115: 100 plus 45, minus 20, minus 10. In the chart, mark Opening cash and Closing cash as totals. The three middle entries remain changes. The opening column should show 100 from the baseline; receipts and payments should bridge between balances; and closing cash should show 115 from the baseline.

If you leave Closing cash as an ordinary change, Excel adds 115 to the previous running balance of 115. The resulting last column rises to 230, which is not the intended closing balance. This is a common source of confusion: the worksheet value can be correct while the chart’s interpretation is wrong. Setting the point as total corrects the chart’s treatment without changing the source value.

You can include a subtotal between movements too. For example, after receipts, a subtotal of 145 can be inserted and marked as a total. Payments listed after that subtotal then continue from 145. Use such a checkpoint when it helps readers understand the story, but avoid adding one after every line; too many totals can make a waterfall chart harder to scan.

Formatting and choosing useful totals

Excel typically distinguishes increases, decreases, and totals visually, but you can adjust the point’s appearance to suit the report. Select the relevant point and use the formatting controls in Format Data Point to change its fill or border. Keep total columns visually consistent with one another, and use colors that remain distinguishable when printed or viewed by people with color-vision differences. Do not rely on color alone: clear category names and data labels provide additional cues.

Use totals where they clarify a meaningful checkpoint. Common choices include:

The starting balance, such as opening cash or starting headcount.
An ending balance, such as closing cash or final profit.
A subtotal that divides a sequence into understandable stages, such as gross profit before operating expenses.

Not every category called “total” should necessarily become a total column. Confirm what its value means. If it is a new movement, leave it as a change even if the source label contains the word total. Conversely, a column called “balance,” “ending position,” or “subtotal” may need the total setting if its value is an absolute checkpoint.

Common problems and how to fix them

The ending bar is too tall or appears to double the result: The closing value is probably being plotted as a change. Select that individual column and choose Set as Total.
The entire series changes when you try to format one bar: The series, rather than a single point, is selected. Click once to select the series, then click the intended column again before opening its context menu.
The total column starts at the wrong height: Check the value in the source cell and confirm that the correct data point was selected. Setting a point as total does not repair an incorrect source value.
A subtotal appears to reset later changes unexpectedly: A marked total establishes the new reference level. Check whether it is an actual subtotal at that point in the sequence and whether later changes are listed after it.
New rows or columns do not appear in the chart: The chart may not include the added source cells. Use Chart Design > Select Data to inspect or adjust the chart data range, then confirm the categories and values are aligned.
You cannot find Set as Total: Make sure the chart is a waterfall chart and that a single data point is selected. If the command is still unavailable, try opening the workbook in the desktop version of Excel for Microsoft 365; commands and editing support can differ in Excel for the web and across app updates.

When figures change, recheck the chart rather than assuming its meaning remains correct. The total designation belongs to the chart point, while the number comes from the worksheet. If you replace or rearrange source categories, verify that the intended opening, subtotal, and ending points are still marked as totals.

Waterfall totals compared with other chart types

A waterfall chart is appropriate when the sequence of changes explains how one balance becomes another. A regular column chart is usually clearer when the categories are independent values, such as sales by region. In a regular column chart, each bar is normally compared with the same baseline; it does not show a running bridge from one value to the next.

A stacked column chart can show how components contribute to a whole across several categories, but it answers a different question: how parts combine within each category. It is not a substitute for a waterfall when the key message is the ordered effect of additions and subtractions on a running balance. If the audience mainly needs to compare start and end values, a simple column chart or a compact table may be easier to read.

For a waterfall chart, the important decision is not just which chart type to insert. Decide which entries are movements and which are absolute checkpoints. That classification determines whether each point should float or begin at the baseline.

Frequently Asked Questions

How do I make the last column a total in an Excel waterfall chart?
Select the last column as an individual data point, right-click it, and choose Set as Total. Confirm that its worksheet value is the intended ending balance.

Can a waterfall chart have more than one total column?
Yes. You can set multiple points as totals, including the first and last values and meaningful intermediate subtotals. Each should represent an absolute amount, not another increase or decrease.

Does Set as Total change the number in my worksheet?
No. It changes how Excel displays that chart point. Edit or calculate the source cell separately if the amount itself is wrong.

Why does my total column start from zero?
That is normally how a total is displayed: it spans from the baseline to the total amount. If its height is unexpected, check the source value, chart scale, and selected data point.

Can I mark a subtotal in the middle as a total?
Yes. Select the subtotal’s column and use Set as Total. Later changes then continue from that subtotal, so make sure it is a genuine balance at that position in the sequence.

Does the total setting affect the worksheet calculation?
No. It is a chart-formatting instruction, not a formula or a change to the source data. Keep the worksheet values and calculations accurate independently of the chart setting.

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.