WPS Spreadsheets: Show Values and Percentages in a 100% Stacked Chart
Question details
The user needs to show actual source values beside a 100% stacked chart while displaying percentages inside the chart segments.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A 100% stacked chart is being used to compare category proportions, but the chart also needs to communicate the original numerical values.
- Observed behavior
- The chart uses percentage-based scaling, so the axis shows proportions while the actual values are not automatically displayed as labels inside or beside the bars.
Prepare the source values and calculate each category's percentage of its row or column total in a helper range. Select the existing chart and confirm whether it is a 100% stacked column or bar chart before changing its labels.
Add actual values to the 100% stacked chart
Use this method when the percentage axis is sufficient and you mainly need the original values visible on the chart.
A 100% stacked chart automatically normalizes each bar to 100%, so its axis represents percentages rather than original totals. Adding value data labels lets readers see the underlying numbers without changing the chart scale.
Click the 100% stacked chart in WPS Spreadsheets to display the chart editing tools.
Open the chart tools and choose Add Chart Element or Chart Elements, then select Data Labels and choose a position such as Outside End or Center.
Right-click a data label and choose Format Data Labels. In the label options, enable Value and disable options that show only the series name or category name.
Leave the value axis formatted as Percentage so readers can compare proportions while the data labels show the original values.
Use helper percentages for labels inside the chart segments
Use this method when each segment must display its percentage inside the bar as well as the original values beside the chart.
Build clearer 100% stacked charts in WPS Spreadsheets
WPS Spreadsheets lets you create 100% stacked charts, add value labels, and use helper percentage ranges to present both proportions and original numbers in one visualization.
- 1. Prepare the data: Open WPS Spreadsheets and place the source values and helper percentage formulas in the worksheet.
- 2. Insert the chart: Select the data range, open the Insert tab, choose Chart, and select the 100% Stacked Column or 100% Stacked Bar type.
- 3. Add values: Select the chart, open Chart Elements, choose Data Labels, and enable Value in Format Data Labels.
- 4. Add percentages: Use Value From Cells or a custom label range to select the helper percentage cells, then set their position to Center or Inside End.
Frequently Asked Questions
Why does my 100% stacked chart show percentages instead of the original totals?
A 100% stacked chart normalizes each bar to 100%, so its value axis represents proportions. Add data labels and enable Value in Format Data Labels to show the original worksheet numbers.
Can WPS Spreadsheets show percentages inside each stacked segment?
Yes, when the chart label settings provide Value From Cells or a custom label range. Create helper cells with formulas such as =B2/SUM($B2:$E2), format them as percentages, and assign that range to the data labels.
How can I display both values and percentages at the same time?
Keep Value enabled for the original series and assign a helper percentage range to a second label or helper series. If your WPS version supports only one label source, use linked text boxes or a second helper series for the additional labels.
Where do I change the position of chart labels in WPS Spreadsheets?
Select the chart, open Chart Elements, choose Data Labels, then right-click a label and select Format Data Labels. Use Label Position options such as Center, Inside End, or Outside End.
