Fix Excel Chart Axis Values When Sharing a Workbook
Question details
The user needs to keep percentage chart axis values accurate when sharing an Excel workbook between applications.

- Product
- Microsoft Excel chart
- Device & OS
- not provided
- Scenario
- A workbook is shared and opened in another spreadsheet application or version of Excel.
- Observed behavior
- The original chart shows percentages correctly, but the shared copy displays an incorrect value-axis range, such as 0% to 20,000%.
Check the chart's source range and confirm that the percentage cells contain numeric values rather than text. Open a copy of the shared workbook in the application used by the recipient so you can verify the chart after saving.
Set the chart axis bounds and percentage format manually
Use this solution when the chart data is correct but the shared workbook recalculates or reformats the value axis incorrectly.
Percentage values are commonly stored as decimals between 0 and 1, such as 0.2 for 20%. Setting the axis bounds to 0 and 1 prevents the chart from interpreting the data as whole-number percentages.
Select the cells used by the chart and open Home > Number Format or Format Cells. Confirm the values are numeric decimals, such as 0.2, rather than text such as '20%' or whole numbers such as 20.
Select the chart, right-click the vertical value axis, and choose Format Axis. In WPS Spreadsheets, use the chart's Axis or Format Axis panel.
In Axis Options, set Minimum to 0 and Maximum to 1. Set Major unit to a suitable interval, such as 0.2, if you want the axis to show 0%, 20%, 40%, and so on.
In the Format Axis pane, open Number, select Percentage, and choose the required decimal places. Save the workbook and reopen the shared copy to confirm the range remains correct.
Preserve the chart appearance as an image
Use this option when the chart must look identical across applications and editing the chart after sharing is not required.
Fix percentage chart axes in WPS Spreadsheets before sharing
WPS Spreadsheets lets you verify numeric percentage values, format the chart value axis, set fixed minimum and maximum bounds, and save a shareable workbook with familiar spreadsheet tools.
- 1. Open the workbook: Launch WPS Office, choose Spreadsheets, and open the shared .xlsx workbook from File > Open.
- 2. Inspect the chart data: Select the chart and review its source range. Use Home > Number Format or Format Cells to confirm the source percentages are numeric decimal values.
- 3. Format the value axis: Right-click the vertical chart axis and choose Format Axis. Set the minimum bound to 0, the maximum bound to 1, and the axis number format to Percentage.
- 4. Save and verify the shared file: Choose File > Save As, keep the Excel Workbook (*.xlsx) format, and reopen the saved file in the recipient's spreadsheet application to verify the chart.

Frequently Asked Questions
Why does an Excel chart show 20,000% instead of 200% after sharing?
The chart may be interpreting whole-number values or decimal data with an incompatible percentage format. Check the source cells and use numeric decimals between 0 and 1, then set the axis bounds to 0 and 1 and apply Percentage formatting.
What minimum and maximum values should I use for a percentage chart axis?
For data stored as decimal percentages, use a minimum of 0 and a maximum of 1. If your data is intentionally limited to a smaller range, set custom bounds that still match the decimal scale.
How can I tell whether percentage values are stored as text?
Select a source cell and check its alignment, formula bar, and number format. A value with a leading apostrophe or text indicator may be text; use a numeric conversion method, then apply Home > Number Format > Percentage.
Will saving the workbook as an image prevent axis changes?
Yes. Copying or exporting the chart as an image preserves its visual appearance across applications, but the resulting image cannot be edited as a chart or recalculated from the workbook data.




