Excel Stacked Bar Chart: Show Total Data Labels Easily

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, select the stacked bar chart and look in Format Data Labels for Show total; if that option is unavailable, use Value From Cells to place calculated totals at the end of the bars. The second method works without adding a totals series to the plotted stacks, so it avoids changing the bar lengths.

Check for Excel’s built-in Show total option

For a quick check, select the chart, then choose Chart Design > Add Chart Element > Data Labels and add labels. Right-click one of the labels and choose Format Data Labels. In the pane, look under Label Options for Show total. The available controls can depend on the chart type and Excel build, so if you do not see that option for your stacked bar chart, use the cell-based method below.

When the option is available, Excel calculates and displays the sum of the stacked segments for each category. You can usually choose a label position and change the number format in the same pane. Check a few categories against the source data before relying on the labels, especially if the chart contains negative values or missing data.

Do not confuse a total label with the value label for the last segment. A segment label reports only that segment’s value; the total is the combined value across the stack.

Use Value From Cells for a dependable workaround

When there is no Show total control, create a totals range in the worksheet and use it as the source for labels on the final series in each stack. This displays the total at the bar end without adding that total as another plotted segment.

  1. Add a total column beside the component data. For example, put category names in A2:A4 and three components in B2:D4.
  2. In E2, calculate the first category’s total and fill the formula down through E4.
  3. Select the chart’s last component series—the segment at the end of each bar—and add data labels if it does not already have them.
  4. Right-click one of those labels and select Format Data Labels. Under Label Options, select Value From Cells, choose E2:E4, and confirm.
  5. Clear the checkbox for Value so Excel shows the cell totals rather than the last segment’s values. Set Label Position to Outside End.

With category names in A2:A4, component values in B2:D4, and totals in E2:E4, enter =SUM(B2:D2) in E2 and fill it down. For example, if row 2 contains 10, 15, and 5, the formula returns 30. If row 3 contains 8, 12, and 10, it also returns 30. The labels then display the combined values at the ends of the corresponding bars.

The Value From Cells choice is in the data-label formatting pane in desktop Excel versions that support it, including Microsoft 365. If it is missing in your Excel for the web interface, open the workbook in the desktop app to complete the label formatting. The names and arrangement of controls can differ somewhat on Mac, but look for the chart’s data-label formatting options and the cell-range label setting.

Why the last series matters

Excel attaches each data label to a particular plotted series. In a stacked bar chart, the final series is the outermost segment, so its labels are positioned relative to the end of the stack. Replacing those labels with values from the totals range makes the displayed text the total while retaining a useful anchor at the bar end.

This is a display technique: the totals cells provide label text, but they are not themselves added as another bar segment. That distinction matters. If you add a totals column as a new series to a stacked chart, Excel stacks the totals on top of the components. A bar whose components sum to 30 would then extend to 60 if you also stacked a total of 30, which misrepresents the data.

Make sure the order of the selected label series and the totals range match the chart categories. If the chart order differs from the worksheet row order, the labels can show correct totals beside the wrong categories. Sorting the source data or verifying the category order in Select Data helps prevent that error.

Choose a readable label position and number format

Outside End is often the clearest position for a total because it sits beyond the final segment. It needs enough chart space to avoid clipping. If labels disappear at the right edge, widen the chart, reduce the label font, or increase the horizontal value-axis maximum slightly. Leave some space beyond the largest bar so the labels do not collide with the plot boundary.

For bars with different lengths, a consistent position is usually easier to scan than labels placed inside segments. Inside placement may suit a chart with wide bars and a contrasting label color, but short segments can make text difficult to read. Avoid making labels so large that they overlap adjacent categories.

For currency, percentages, or thousands separators, format the totals cells or use the number-format controls for the data labels. Check whether the labels follow the worksheet format in your Excel build; if they do not, set the format in Format Data Labels. Use a format consistent with the axis and source values. A total of 3000 displayed as 3,000 is clearer than a label with unnecessary decimal places.

Special cases: negative values and 100% stacks

For a standard stacked bar chart with positive components, the total is the sum of the displayed segments. With negative values, however, Excel may stack positive and negative portions in opposite directions from zero. A single arithmetic sum is not necessarily the visual endpoint of either side. Decide what the label should communicate: the net sum, the sum of positive values, or another measure. Calculate and label that measure explicitly rather than assuming the visual end represents the net total.

A 100% stacked bar chart normalizes each category so its segments represent proportions adding to 100%. Its natural total is therefore 100% for every complete category, not the original quantity. If readers need the original totals as well as percentages, use a totals range for labels and make clear that those labels are counts, dollars, or another unit—not percentages. The axis and segment labels should not imply that the total amount itself is 100%.

Common problems and fixes

  • The label shows the last segment instead of the total: In Format Data Labels, select Value From Cells and turn off Value.
  • The bar becomes twice as long: Remove the totals series from the stacked chart. Use the totals cells only as label text.
  • Totals appear beside the wrong bars: Check that the selected cell range follows the chart’s category order and has one cell per category.
  • Labels are cut off: Make more room beyond the longest bar or adjust the value-axis maximum. Do not resize the axis so tightly that it misleads readers about differences.
  • Some labels are missing: Check for blank or error cells in the totals range, and confirm that labels are applied to the final series for every category.
  • Labels overlap: Widen the chart, reduce font size, or simplify the number format. A shorter display format can make a dense chart easier to read.

Stacked bar versus stacked column charts

A stacked bar chart uses horizontal bars; a stacked column chart uses vertical columns. Both show component values combined into categories, and the same general approach—built-in totals when available, or cell-based labels otherwise—can apply to either. The label position is named relative to the chart orientation: for horizontal bars, Outside End means beyond the right end for positive values; for columns, it means above the top.

Choose a stacked chart when the reader needs to compare both category totals and their component makeup. If the main goal is comparing each component across categories, a clustered bar chart may make that comparison easier, because each component gets its own position rather than being embedded in a stack. If the main goal is comparing composition rather than quantity, a 100% stacked chart may be more suitable, with the caveat that it hides differences in total size.

Frequently Asked Questions

Can Excel show totals on a stacked bar chart automatically?
Some desktop Excel chart formats expose a Show total option in the data-label settings. If it is not available for your chart, use Value From Cells with a worksheet totals range.

Can I show total and segment values at the same time?
Yes. Keep the component labels on the relevant series and add total labels using the totals range on the final series. Check that the extra text does not overcrowd the bars.

Do I need to add the totals column to the chart?
No. For the cell-based method, the totals range supplies label text only. Adding it as a plotted series in a stacked chart would add the totals to the bar lengths.

Can I use this method with a PivotChart?
PivotCharts can have restrictions on data-label options, and available controls vary. If you cannot use a cell range for labels, create a regular chart from the PivotTable output or a copied summary range, then apply the label method there.

Why does the total label not match the visible bar?
Check whether the chart is 100% stacked, whether any components are negative, and whether the totals formula includes exactly the plotted components. A 100% stack shows normalized shares, while a formula may calculate original amounts.

Will the labels update when source values change?
If the totals formulas reference the component cells and the labels refer to those total cells, both update when the source values recalculate. If you add new categories, extend the chart and label ranges so the new rows are included.

Related

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.