How to Show Grand Totals on a Stacked Column Chart in WPS Office Spreadsheet
Question details
The user wants to add total labels above each stacked column in a chart, rather than seeing labels only for the individual segments.
- Product
- WPS Office Spreadsheet
- Device & OS
- macOS
- Scenario
- The user is working with a stacked column chart in WPS Office Spreadsheet on macOS and wants each column to display its grand total above the stack.
- Observed behavior
- The chart currently shows data labels only for individual segments, and no label appears for the total of each stacked column.
Make sure your source data includes a Total row or column for each category, and select the chart in WPS Office Spreadsheet before opening the Select Data dialog.
Add the grand total as a separate line series and format its data labels
Use this method when you need automatic totals that update with the source data and want a single label above each stacked column.
Stacked column charts normally show labels for each segment rather than for the whole column. Adding a Total series and changing it to a line lets WPS Office Spreadsheet place one label per category above the stack without adding another visible column.
The Total line is hidden, so the chart still looks like a stacked column chart, but the Total data labels remain above the columns and update when the source data changes.
In WPS Office Spreadsheet, add a Total row or column to your source range and use a SUM formula or manually entered values so each category has a grand total.
Click the stacked column chart to select it, go to the Chart Tools tab, and click Select Data. You can also right-click the chart and choose Select Data.
In the Select Data dialog, click Add, set the series name to Total, and select the total values as the series values. Click OK to insert the series into the chart.
Right-click the Total series in the chart and choose Change Series Chart Type. Set the Total series to Line and keep the original series as Stacked Column.
Right-click the Total line, choose Format Data Series, and set the line to No Line. Then right-click the Total series again, choose Add Data Labels, and set the label position to Above.
Show Grand Totals on a Stacked Column Chart in WPS Office Spreadsheet
WPS Office Spreadsheet can add grand totals to a stacked column chart by adding a Total series, changing it to a hidden line, and placing data labels above the columns. This keeps the chart clean and makes the totals update with the source data.
- 1. Download and install WPS Office: Go to the official WPS Office website, download the macOS version, and install it. Then open your stacked column chart workbook in WPS Office Spreadsheet.
- 2. Add a Total row or column: Select your chart data and insert a Total row or column with SUM formulas so each category has a calculated grand total.
- 3. Add the Total series to the chart: Select the chart, click Chart Tools > Select Data, and use Add to create a Total series from the values you just prepared.
- 4. Convert the Total series to a line and hide it: Right-click the Total series, choose Change Series Chart Type, select Line, and format the line as No Line.
- 5. Add data labels above the columns: Right-click the hidden Total series, choose Add Data Labels, and set the label position to Above to show one grand total per stack.
Frequently Asked Questions
Can I show grand totals on a stacked column chart in WPS Office Spreadsheet for Mac?
Yes. Add a Total series to the chart, change that series to a Line chart, hide the line by setting it to No Line, and then add data labels positioned above the columns.
Why are my total labels missing on a stacked column chart?
A standard stacked column chart displays data labels for each segment, not for the column total. You need to create a separate Total series and add labels to that series instead.
Does the Total series have to be a line chart?
It does not have to remain visible as a line. Changing the Total series to a Line chart lets you hide the line and place its data labels above each category without adding another visible bar.
Will this method work when I open the workbook in Microsoft Excel for Mac?
Yes. WPS Office Spreadsheet saves the combo chart and data label settings in a standard .xlsx format, so the totals remain visible when the file is opened in Excel 365 for macOS.
What if my total values are already in the chart but appear as a stacked segment?
Format that series as a Line instead of a stacked column, set the line to No Line, and change its data label position to Above so it becomes a clean total label above the stack.
