To show totals on an Excel stacked column chart, add a row or column of totals to the worksheet, select the chart’s top series, and use data labels from those total cells. In Excel for Microsoft 365 on Windows, choose Chart Design > Add Chart Element > Data Labels > Outside End, then set the labels to Value From Cells and select the total range.
How Excel stacks the values
A stacked column chart draws each category as one column made of segments, with each segment representing a series. For example, a chart of quarterly sales might stack sales from three product lines. The full column height represents the combined value, but the standard label for an individual segment shows only that series’ value—not the sum of all the segments.
Excel does not provide a single built-in chart setting called Show Grand Total for a stacked column chart. Instead, you can calculate the totals in worksheet cells and use those cells as data-label text. This keeps the displayed total connected to the underlying data and avoids adding the total a second time to the visible stack.
Assume categories are in A2:A5 and the three series are in B2:D5, with headers in row 1. In E1, enter Total. With the first category’s values in B2:D2, enter =SUM(B2:D2) in E2, then fill the formula down through E5. The totals for a row of 12, 8, and 5, for example, add to 25. Use the totals column as the source for labels, not as another stacked column series.
Method 1: Use total cells as data labels
This is usually the cleanest approach when your data has positive values and the same series is the top segment in each column. It changes the text shown on the chart without changing the plotted values or the column heights.
- Calculate one total for each category beside the source data. Keep the totals in the same order as the chart categories.
- Select the chart, then click a segment in the series that forms the top of each stack. A second click may be needed to select the series rather than the whole chart.
- On the ribbon, choose Chart Design > Add Chart Element > Data Labels > Outside End. This adds labels for that series.
- Right-click one of the new labels and choose Format Data Labels. In the pane, under Label Options, select Value From Cells. Select the total cells in the worksheet and confirm the range.
- In the same pane, clear Value if you want only the totals rather than both the segment value and total. Leave the label position at Outside End, or choose another available position if it suits the chart.
The label is attached to the selected series point, while its wording comes from the total cell. Because that series is at the top of each positive stack, Outside End places the total above the column. If you add categories later, extend the total formulas and update the label range if Excel has not included the new rows automatically.
When cell-based labels are the right choice
Use Value From Cells when the goal is to print a calculated number above each column and your chart’s top series reliably marks the top of every stack. This option is especially useful when you want formatted labels such as currency, percentages, rounded numbers, or text that differs from the underlying plotted value. The source cells control the label text; the chart still uses the series data to draw the segments.
One limitation matters: labels belong to points in a particular series. If that series has a zero, blank, or missing value for a category, its point may not sit at the top of that category’s stack. The total label can then appear inside the column or at an unexpected height. Check every category after applying the labels, especially if the top series changes or contains zeros. If the top segment is not consistently present, use a total helper series instead.
Method 2: Add a total helper series
A helper series can position a label at each calculated total even when the top segment varies by category. It should be displayed as a line over the stacked columns, not as another stacked column. If you add totals as a stacked column series, Excel adds them to the stack and makes each column too tall.
- Add the calculated total column to the chart data. If Excel does not add it automatically, select the chart and choose Chart Design > Select Data to include the total series.
- With the chart selected, choose Chart Design > Change Chart Type. In the Combo category, set the original component series to Stacked Column and the total series to Line.
- Keep the total line on the primary axis; do not select Secondary Axis. This allows its values to use the same scale as the stacked columns.
- Select the line series and add labels using Chart Design > Add Chart Element > Data Labels > Above.
- Format the total series so it does not distract from the columns. In Format Data Series, set the line to No line and the marker to None, while keeping the data labels visible.
The invisible line points remain aligned with the total values, so their labels sit at the top of the stacks. This method is useful when the series that contributes the topmost segment differs between categories. Review the chart after formatting: if the line is on a secondary axis or the axes have different scales, labels may not align with the column tops. For data with negative values, visual stack boundaries can be more complicated because positive and negative segments extend in opposite directions from zero; confirm that the label represents the boundary you intend to show.
Choose a clear number format and position
Totals are useful only if readers can distinguish them from the segment labels. A common design is to keep segment values inside the columns and show the total just above each column. Use a consistent number format, such as whole numbers or currency, and avoid showing unnecessary decimal places. If the total cells use a specific number format, check whether the chart labels reflect it; the Format Data Labels pane may offer a Number section for setting the display format.
Leave enough space above the tallest column for its label. If the top label is clipped, select the vertical axis and increase its maximum bound, or enlarge the chart area. Do not reduce the maximum so far that the tallest columns or labels are cut off. For a crowded chart, make the chart wider, shorten category names, or reduce label font size before moving labels into the stack, where they may be harder to read.
Common problems and fixes
- The chart shows both the segment value and the total. Open Format Data Labels and clear Value while keeping Value From Cells selected.
- The total labels are in the wrong order. Make sure the selected worksheet range matches the chart categories from first to last. The label range should have one cell per category.
- The labels appear at the wrong height. With cell-based labels, confirm that you selected the actual top series and that its point is present in every category. Otherwise, try the line helper-series method.
- The columns became taller after adding totals. The total series was added as another stacked column. Change it to a line series, or remove it and use Value From Cells.
- The top labels are missing or clipped. Check that data labels are enabled for the intended series and increase the vertical axis maximum or chart height to leave room.
- New categories have no total label. Extend the total formula and check whether the chart’s source data and Value From Cells range include the added rows.
Also check whether the chart is displaying hidden data. Chart Design > Select Data opens the source-data settings; the Hidden and Empty Cells controls can affect which values appear. A blank cell is not necessarily the same as a calculated zero, so choose the data and chart behavior that accurately represents your report.
Excel for Mac and Excel for the web
In current Excel for Microsoft 365 on Windows, the ribbon and Format Data Labels pane provide the paths described above. Excel for Mac has similar chart-label controls, though ribbon placement and pane wording can differ between releases. Select the chart, add labels from the Chart Design tab, then look in the formatting pane for Value From Cells and the label-position options. A Windows-only keyboard shortcut is not required for either method.
Excel for the web can edit many chart elements, but some advanced formatting controls may differ or be unavailable compared with the desktop application. If you cannot find Value From Cells or cannot format a combo chart as needed, open the workbook in the Excel desktop app. The worksheet total formulas and chart data remain usable across these versions.
Frequently Asked Questions
Can Excel show the total above each stacked column automatically?
There is no universal one-click Show Total setting for a stacked column chart. Calculate totals in cells and use Value From Cells for labels, or use a line helper series when labels need to follow totals independently of the top segment.
Can I add total labels without changing the column heights?
Yes. Cell-based data labels only change the displayed text. A helper series also preserves column heights if you set it to Line rather than Stacked Column. Avoid adding the totals as another visible stacked segment.
Can I show totals and individual segment values together?
Yes. Keep the usual value labels on the component series and add total labels from the total cells. Position segment labels inside the columns and totals outside the end, then check for overlaps in small or crowded charts.
Why is my total label not at the top of the column?
With Value From Cells, the label is positioned using the selected series point, not the total cell’s value. If that series is zero or absent in a category, its point may not mark the stack’s top. Use a total line series on the primary axis or select a consistently topmost series.
Will the totals update when my data changes?
They will if the total cells contain formulas that refer to the component values. The chart labels update from those cells when the workbook recalculates. If you add categories, ensure both the chart source range and the label range include the new rows.
Related
- Conditional Formatting in Excel: Compare Dates
- Comparison Spreadsheet Template Excel: Setup and Examples
- Comparison Table Excel Template: Build, Format, and Use
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Bar Graph: Sort Values Largest to SmallestTo sort an Excel bar graph from largest to smallest, sort the chart’s source data by its value…
- Excel Pivot Pie Chart: Create, Filter, and Fix OneYes—Excel for Microsoft 365 on Windows can create a pie PivotChart from a PivotTable. Select a cell in…
- Excel Pivot Table: Filter and Sort AlphabeticallyYes. In Excel for Microsoft 365 on Windows, click a PivotTable row or column label, open its drop-down…
- Excel Bar Graph: Count Occurrences and Chart ResultsTo count how often each category appears in Excel and show the totals in a bar graph, make…
- Stacked Waterfall Chart in Excel: Handling NegativesExcel’s built-in Waterfall chart can show positive and negative changes, including a running balance that falls below zero,…
- Does Excel Have a Gantt Chart Template? How to Use ItYes. Excel has Gantt chart templates you can find through its template gallery or Microsoft Create, although the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.