Excel Waterfall Chart Data Labels: Add and Format Them

To add labels to an Excel waterfall chart in Microsoft 365 for Windows, select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position such as Outside End. You can format the labels, show totals, or—in supported desktop versions—use text from worksheet cells for custom labels.

What waterfall chart labels show

A waterfall chart explains how a starting amount changes through a sequence of increases and decreases to reach an ending amount. Its data labels usually display the underlying value for each category: a positive change, a negative change, or a total. For example, a sequence might begin at 100, increase by 25, decrease by 10, and finish at 115. Labels can make each step easier to read without requiring someone to estimate bar heights against the axis.

Labels are different from the category names along the horizontal axis. A category might be called “New customers,” while its data label shows the amount of the increase. Excel may also show the category name as part of a label, but that is an optional label component. The chart’s source cells remain the source of the values; adding labels does not change the calculations or the chart data.

One important detail is that a waterfall chart can treat selected bars as totals. A total bar starts from the chart baseline rather than continuing from the previous step. Marking a point as a total changes how Excel draws it; it does not automatically calculate a total in your source data. The value you want shown for that point should therefore be present in the chart’s data range.

Add data labels to a waterfall chart

These steps apply to the desktop version of Excel for Microsoft 365 on Windows. First select the chart so the chart-specific ribbon tabs appear. Then use the ribbon or the chart’s plus button to add labels:

Click the waterfall chart. If you do not have one yet, select the category and value data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.
Choose Chart Design > Add Chart Element > Data Labels.
Select a position, such as Outside End, Inside End, or Center. The available positions can vary with the chart and Excel build.
Check that the labels show the information you want. If necessary, right-click a label and choose Format Data Labels to open the formatting pane.

You can also click the chart’s Chart Elements button, shown as a plus sign beside the chart, and select Data Labels. The button is a quick way to switch labels on or off; Chart Design gives more choices about placement. If labels are crowded, try another position before reducing the font size. A placement that works for positive bars may overlap the baseline or nearby categories for negative bars.

To label only one bar, click a label once to select the full set, then click the label for the individual point again. You can format or delete that selected point’s label without changing every other label. Selection can be fiddly, so check the selection before pressing Delete: a second click should select one point, while a single click generally selects the whole set.

Show and identify total bars

Waterfall charts commonly use totals for the opening balance, closing balance, or important subtotals. To make a bar a total, right-click that data point and choose Set as Total. If the context menu does not show the command, click the bar once to select the series and again to select the point, then open its context menu. The bar should then begin at the axis baseline, distinguishing it from the floating increase and decrease bars.

Consider a simple example: an opening balance of 100, a change of +25, and a change of −10 lead to a closing balance of 115. The closing value should be included as a row in the chart’s source data, and that point should be marked as a total. The label for the ending bar can then show 115, while the intermediate labels show +25 and −10. If the closing bar looks like another floating change, check that you marked the correct point as a total.

Excel does not infer every subtotal from the visual story you intend to tell. It plots the values in the selected range and uses the Set as Total setting to control how particular points are drawn. If you change or rearrange the source data, check both the total-bar settings and the displayed labels afterward.

Format label content and appearance

Right-click a label and choose Format Data Labels to open the Format Data Labels pane. Under Label Options, you can choose which available items to show, such as Value, Category Name, or Series Name. For a typical single-series waterfall chart, Value is the useful default. Category Name can help when the axis labels are long or angled, but showing both the category and value may make a compact chart feel crowded.

Use the Number section of the pane to control how values appear. A suitable number format can add a thousands separator, set decimal places, or display negatives in parentheses. For example, a chart reporting whole dollars may be clearer with no decimal places, while a chart of small percentage-point changes may need one or two. Choose a format that matches the units and precision of the source data; a label that rounds a small change to zero can be misleading.

If the label format follows the source cells, changing the source number format may also affect the chart labels. In the formatting pane, the option to link to source formatting can control that behavior where available. If the chart needs a different format from the worksheet, adjust the label number format directly and verify the result after editing the underlying values.

You can also adjust label font, size, color, and alignment using the Home tab or the formatting controls for the selected labels. Keep contrast high enough to read against the plot area and bars. Avoid placing a negative value inside a dark bar if the text becomes hard to see; a different label position or font color is usually clearer than adding decorative effects.

Use worksheet cells for custom labels

Sometimes the numeric change is not the best text to display. A report may need labels such as “Contract signed,” “One-time cost,” or “Revised forecast,” or it may need formatted wording that does not match the raw values. In desktop Excel versions that offer the feature for the selected chart, you can use cell contents as data labels.

Enter the label text in worksheet cells, with one cell corresponding to each chart point you want to label.
Select the chart labels, right-click, and choose Format Data Labels.
Under Label Options, select Value From Cells, then select the worksheet range containing the desired text and confirm.
Clear Value if you want the custom wording instead of the numeric source value. Leave Value selected if readers should see both.

Keep the selected cell range aligned with the plotted points, and confirm the order: a label beside the wrong bar can be more confusing than no label. If Value From Cells is not shown, check that you are working in a supported desktop Excel version and that the data labels, rather than the chart or an individual text box, are selected. Availability and the pane layout can differ between builds and chart types. In Excel for Mac, the chart tools and formatting pane are arranged differently, but the same general approach is to select the labels and look for Value From Cells in label options. Excel for the web may not provide the same full chart-formatting controls as the desktop app.

Fix missing, overlapping, or unexpected labels

When labels do not appear as expected, work through the likely causes rather than rebuilding the chart immediately:

No labels appear: Select the chart and verify that Data Labels is enabled under Chart Design > Add Chart Element. If only one point is missing a label, select that point and check whether its label was deleted individually.
Values look wrong: Check the chart’s selected data range and the underlying cells. A waterfall label reflects the plotted source value; it does not necessarily calculate the running balance for every step.
The ending value looks like a change: Right-click the relevant point and check Set as Total. Also confirm that the source row contains the intended ending amount.
Labels overlap bars or one another: Try Outside End, Inside End, or another available position, enlarge the chart, or reduce the number of displayed label components. Long category names may be better left on the axis than repeated beside every bar.
Negative signs or decimals are missing: Check the number format and decimal-place settings in Format Data Labels. A custom format may hide a sign or round a small value, so compare the display with the source cell.
Custom text is attached to the wrong bar: Make sure the Value From Cells range contains labels in the same order as the chart categories. Edit the selected range if the source data has been sorted or extended.

Labels can also be clipped when the chart is too small or a value is close to the edge of the plot area. Increase the chart size or adjust the plot area before shrinking the text to an unreadable size. If a chart updates from a changing range, confirm that new categories are included in both the plotted data and any custom-label range.

Choose labels that clarify the story

More labels do not always make a waterfall chart more informative. A chart with a small number of steps may benefit from values on every bar. A chart with many small changes can become a dense block of text, especially when it also has long category names. In that case, consider labeling only the opening and closing totals, key milestones, or unusually large changes, and keep the exact figures in a nearby table.

For a chart intended to compare the size and direction of individual changes, show positive and negative values consistently. Keep units clear—dollars, units sold, hours, or percentage points—and do not rely on color alone to explain a change. Readers may print the chart in grayscale or have difficulty distinguishing colors, so a minus sign and readable label placement matter.

Use a chart title or axis title to explain what the values measure, and ensure that the displayed precision is appropriate. For instance, an operational chart showing changes of 3, 8, and −2 units rarely benefits from several decimal places. A financial report may need currency symbols or a note that values are in thousands. Labels should support the chart’s purpose rather than compete with it.

Frequently Asked Questions

How do I show values on every bar in an Excel waterfall chart?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position. If labels appear for only some bars, inspect whether individual labels were removed or whether the chart data contains the points you expect.

Can I show a running total on every step?
Excel’s standard waterfall labels display the values associated with the plotted points, not automatically calculated running balances for every step. To show running totals, calculate those balances in worksheet cells and use them as custom labels with Value From Cells if that option is available, or add the balances in a separate table.

How do I add a label to just one waterfall bar?
Add labels to the chart, click the labels once, then click the specific point’s label again. Right-click that selected label to format it, or press Delete to remove only that point’s label. Verify the selection before deleting because one click may select the full set.

Why does my total bar not start at zero?
The point may not be marked as a total. Right-click the bar and choose Set as Total. Also confirm that the data point is the intended subtotal or ending value, rather than an intermediate increase or decrease.

Can I put text instead of numbers in the labels?
Yes, in supported desktop Excel chart-label controls, use Value From Cells in the Format Data Labels pane and select cells containing the wording. Clear Value if you do not want the numeric amount shown alongside the custom text.

Can I add waterfall data labels in Excel for the web?
Some chart editing and formatting controls may be limited compared with Excel for Windows or Mac. If the web interface does not show the label options you need, open the workbook in the desktop app and use Chart Design > Add Chart Element > Data Labels.

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.