Fix a WPS Spreadsheet Chart Axis Stuck at 0% to 100%
Question details
The user needs to make a chart display numeric values such as 1,000 to 3,000 instead of a percentage axis locked at 0% to 100%.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user created a chart for data across years 2010 through 2020 with values such as 1,000 to 3,000, but the vertical axis displays percentage labels.
- Observed behavior
- The chart axis is stuck at 0% to 100% instead of showing the actual numeric values.
Click the chart to confirm the Chart Tools tab appears on the ribbon, and note the current chart type shown in the Change Chart Type dialog before making changes.
Change the 100% Stacked chart type to a Clustered chart
Use this when the chart was created as a 100% Stacked Column, Bar, or Line chart, which always shows a 0%–100% axis.
100% stacked chart types compare each value as a percentage of the total across categories. They are not designed to show absolute values such as 1,000 to 3,000 on the value axis.
Click the chart in your WPS Spreadsheet worksheet so the Chart Tools context tab appears.
Go to the Chart Tools tab on the ribbon and click Change Chart Type.
In the Change Chart Type dialog, select Clustered Column, Clustered Bar, or another non-100% stacked type, then click OK.
Confirm that the vertical axis now displays numeric values such as 1,000, 2,000, and 3,000 instead of percentages.
Switch a percentage line chart to a standard Line chart
Use this if the chart is a 100% Stacked Line variation that forces a percentage vertical axis.
Fix a Percentage-Locked Chart Axis in WPS Spreadsheet
You can fix the percentage axis in WPS Spreadsheet by changing the chart from a 100% stacked type to a clustered or standard chart type so the value axis shows actual numeric values.
- 1. Open your workbook: Launch WPS Spreadsheet and open the workbook that contains the chart.
- 2. Select the chart: Click the chart to activate the Chart Tools tab.
- 3. Change the chart type: Click Change Chart Type and choose Clustered Column or another non-100% stacked chart type.
- 4. Confirm the axis: Click OK and check that the vertical axis now displays numeric values instead of percentages.
Frequently Asked Questions
Why does my chart axis only show percentages from 0% to 100%?
This usually happens when the chart is a 100% Stacked Column, Bar, or Line chart. These chart types always use a percentage axis. Change the chart type to Clustered Column, Clustered Bar, or standard Line to show numeric values.
How do I change a 100% Stacked chart to a Clustered chart in WPS Spreadsheet?
Select the chart, go to Chart Tools > Change Chart Type, choose Clustered Column or Clustered Bar, and click OK.
Will changing the chart type affect my data?
No, changing the chart type does not modify the underlying worksheet data. It only changes how the data is plotted.
Can I keep a stacked chart but show actual values instead of percentages?
Yes, use a regular Stacked Column or Stacked Bar chart instead of a 100% Stacked chart. Regular stacked charts show absolute values on the value axis.
My chart still shows percentages after changing the type. What should I check?
Open Change Chart Type again and confirm the selected type is not a 100% stacked variation. Also click the vertical axis, open Format Axis, and check that Number is set to General or Number rather than Percentage.
