Chart & Visualization Issues

Fix Excel Chart Axis Values When Sharing a Workbook

Jason MillerJason Miller Nov 12, 2026 868 views

Question details

The user needs to keep percentage chart axis values accurate when sharing an Excel workbook between applications.

Fix Excel Chart Axis Values When Sharing a Workbook
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%.
Before you start

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.

Solution 1Recommended

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.

1
Check the source values

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.

2
Open Format Axis

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.

3
Define the axis bounds

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.

4
Apply percentage formatting

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.

Expected result: The chart uses a fixed 0–1 data scale and displays the value axis as 0% to 100% instead of an inflated range such as 0% to 20,000%.

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. 1. Open the workbook: Launch WPS Office, choose Spreadsheets, and open the shared .xlsx workbook from File > Open.
  2. 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. 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. 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.
Set percentage chart axes to reliable 0–1 bounds and Percentage formatting.Check and correct numeric source values before sharing the workbook.Use a familiar, lightweight spreadsheet interface for chart editing.Open and save Microsoft Excel .xlsx workbooks with broad format compatibility.
microsoft office alternative - wps office

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.