How to Enable Data Labels in a 100% Stacked Excel Chart in WPS Office
Question details
The user needs to add or fix data labels on a 100% stacked chart in WPS Spreadsheet when the Data Labels button appears unavailable or percentages are missing.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user is working with a 100% stacked column or bar chart and wants each segment to show its value or percentage clearly.
- Observed behavior
- The Data Labels option appears unavailable, or labels are added but percentages are missing from the 100% stacked chart.
Select the chart before opening label options; if you click the worksheet or axis first, the Data Labels button may remain unavailable. Confirm the chart type is set to 100% Stacked Column or Bar.
Add data labels with the Chart Elements button
Use this when the chart is already inserted and you want the quickest way to display values or percentages on a 100% stacked chart.
The Chart Elements button appears next to the chart when it is selected. It includes a Data Labels option even if the ribbon button looks unavailable.
Click the 100% stacked column or bar chart in your WPS Spreadsheet worksheet so the chart handles appear.
Click the plus icon, Chart Elements, that appears at the upper-right corner of the selected chart.
Check the Data Labels box. WPS adds labels to each segment of the 100% stacked chart.
Click the arrow next to Data Labels and choose Data Callout, Center, Inside End, or Inside Base depending on your preferred position and format.
Right-click a data label and choose Format Data Labels; then adjust Number, Label Position, and Separator settings.
Add data labels from the chart context menu
Use this if the Chart Elements button is not visible or you prefer the right-click workflow.
Add and Format 100% Stacked Chart Data Labels in WPS Office Spreadsheet
WPS Office Spreadsheet provides built-in chart tools to add data labels, display percentages, and format them directly on 100% stacked charts without leaving the workbook.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the Excel-compatible workbook that contains the 100% stacked chart.
- 2. Select the target chart: Click the chart to activate the Chart Tools tab and display the Chart Elements button.
- 3. Enable data labels: Check Data Labels from Chart Elements or right-click the chart and choose Add Data Labels.
- 4. Format percentages: Use Format Data Labels to select Percentage, adjust the number format, and set the label position.
- 5. Save or share: Save the workbook in .xlsx format to keep the labels when opening in Microsoft Excel.
Frequently Asked Questions
Why is the Data Labels button greyed out in my 100% stacked chart?
The chart may not be selected, or you may be clicking the axis instead of the chart area. Click the chart first, then open Chart Elements or the right-click menu to see the Data Labels option.
How do I show percentages instead of values on the labels?
Select the data labels, right-click and choose Format Data Labels. Open Label Options or Number, choose Percentage, and set the desired decimal places.
Can I label only one series in a 100% stacked chart?
Yes. Click the series or a single data point first, then add or format data labels. The label settings will apply only to the selected series or point.
Will the data labels remain when I open the file in Microsoft Excel?
Yes. If you save the workbook in .xlsx format, WPS Office preserves the chart and data labels for Microsoft Excel compatibility.
