Fix Excel Chart Percentages and External Workbook References
Question details
Correct percentage displays on an Excel chart's secondary axis and repair an invalid external workbook reference.

- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- An Excel chart uses data from another workbook, with some series plotted on a secondary axis.
- Observed behavior
- Secondary-axis series display raw values instead of percentages, and one series has an invalid external reference that reports the source worksheet must be open.
Identify the source workbook and worksheet for each affected chart series. Check whether the source values represent percentages as decimals, such as 0.25 for 25%, or as whole numbers, such as 25.
Repair the chart's external data references
Use this method when a chart series points to an invalid file or requires the source workbook to be open.
Open the workbook containing the chart and the workbook containing its source data in Excel.
Select the chart, go to Chart Design > Select Data, and select the affected series under Legend Entries (Series).
Click Edit and select the correct series name and values in the open source worksheet. Repeat for any other series with invalid references, then click OK.
If the external reference remains unreliable, copy the chart or source data so both are in the same workbook. Use Chart Design > Select Data to point each series to the local cells.

Format the secondary axis and data labels as percentages
Use this method when chart values are correct but the axis or labels show raw numbers.
Check calculation settings when Excel runs out of resources
Use this temporary workaround if a complex workbook reports insufficient resources during calculation.
Work with spreadsheet charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and charts. It supports Excel formats for easier migration, although it does not repair Microsoft Excel itself.

Frequently Asked Questions
Why does my Excel chart show 2500% instead of 25%?
The source value may be 25 rather than 0.25. Percentage formatting multiplies the displayed value by 100, so use a decimal value or a formula that divides the whole-number percentage by 100.
How do I find the workbook a chart series refers to?
Select the chart and choose Chart Design > Select Data. Select the series and click Edit to inspect its name and values references.
Can I remove the chart's external workbook dependency?
Place the chart and its source data in the same workbook, then use Chart Design > Select Data to relink the series to local cells. Also check whether the source cells contain formulas that still refer to another workbook.
Why are my chart labels still showing numbers after I format the axis?
Axis formatting and data-label formatting are separate. Right-click a data label, choose Format Data Labels, and set its Number format to Percentage.
Will manual calculation fix an Excel resource error?
It can reduce automatic recalculation while you investigate, but it may not fix the underlying cause. Select Formulas > Calculation Options > Manual, then use Formulas > Calculate Now when you need updated results.




