Chart & Visualization Issues

Fix Excel Chart Percentages and External Workbook References

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

Correct percentage displays on an Excel chart's secondary axis and repair an invalid external workbook reference.

Fix Excel Chart Percentages and External Workbook References
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.
Before you start

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.

Solution 1Recommended

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.

1
Open both workbooks

Open the workbook containing the chart and the workbook containing its source data in Excel.

2
Inspect the series

Select the chart, go to Chart Design > Select Data, and select the affected series under Legend Entries (Series).

3
Relink the data

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.

4
Keep data together if needed

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.

Repair the chart's external data references
Check copied formulas: Moving data into the chart workbook does not automatically remove external links from formulas in the copied cells. Inspect those formulas and update them if needed.
Free Microsoft Office alternative

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.

Create and edit spreadsheet charts with WPS SpreadsheetsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday editingMove existing Office documents into a lightweight, free suite
microsoft office alternative - wps office

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.