Excel Chart Linking Errors: Are All Links Really OK?

Charts & pivot tables · Updated November 19, 2026

No: an Excel workbook can report that its external links are fine while a chart still points to the wrong cells, an unavailable range, or an old workbook path. Check the chart’s own series references as well as the workbook’s external links; one being valid does not prove the other is.

What a chart linking error means

An Excel chart is built from one or more data series. Each series has a name, a set of values, and, depending on the chart type, category labels or X values. Excel stores references to those ranges in the chart. A chart linking error means that one or more of those references cannot be resolved, no longer points to the intended data, or cannot retrieve the source it needs.

The visible symptom varies. A chart may show a warning, appear blank, omit a series, display old values, or show an unexpected range. Sometimes the chart looks normal until someone changes the source workbook or opens the file on another computer. A message saying that workbook links are all okay is not a universal chart-health check: it usually concerns external workbook references, not every range and setting in every chart.

For example, a chart might use a local range on the worksheet while a formula elsewhere links to another workbook. The workbook link can be healthy even if the chart points at the wrong local column. Conversely, a chart may explicitly refer to a sheet in another workbook, and a broken external reference can affect the chart even when other workbook links still work.

Chart references and workbook links are different

Excel uses links in several related but distinct ways. Ordinary formulas can refer to cells in another workbook. A chart series can refer to cells in the current workbook or to an external workbook. A linked picture or an embedded object may also have a source. Seeing a status about one category does not establish that all the others are correct.

In Microsoft 365 for Windows, the Data tab may offer a Workbook Links command for managing external workbook connections. The exact controls can vary with the workbook and Excel build; older versions commonly used Edit Links. These tools can help identify a missing source file or update a workbook connection. They do not tell you whether a chart is plotting the right columns, whether its series is missing a row, or whether the chart’s labels are appropriate.

A chart formula is a separate clue. Select a chart series and Excel may show a SERIES expression in the formula bar, such as =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$6,Sheet1!$B$2:$B$6,1). In this example, the series name is in B1, the category labels are in A2:A6, the plotted values are in B2:B6, and the final argument gives the series order. The expression is not an ordinary cell formula to copy into a worksheet; it describes the selected chart series. A chart with several series has separate references for each one.

How to inspect a chart’s data source

Start by checking what the chart actually plots, rather than relying only on a workbook-links status. Save a copy first if you are about to change references, especially when the chart is part of a report used by other people.

  1. Select the chart, then choose Chart Design > Select Data on the Windows ribbon. If the chart is selected, the Chart Design tab appears.
  2. In the Select Data Source dialog, review the Chart data range and the entries under Legend Entries (Series). Check that the listed series are the intended ones and that their names and ranges match the worksheet.
  3. Select a series and choose Edit to inspect its series name, series values, and category labels or X values. Confirm the sheet name, columns, and first and last rows.
  4. Click the chart itself and then click a plotted line, bar, or other series if you need to inspect its SERIES expression in the formula bar. With multiple series, select each one in turn.
  5. Compare the references with the source table, including whether headers, totals, blank rows, or newly added records have been included by mistake.

For a scatter chart, X values and Y values are separate numerical ranges, so check both. For a line or column chart, the horizontal axis commonly uses category labels, which are not the same thing as a scatter chart’s numeric X values. A chart can therefore have references that technically work but still tell a misleading story if the wrong labels or values are assigned.

Fix common chart linking problems

If the chart points to the wrong cells, use Chart Design > Select Data to edit the affected series or chart data range. Choose the correct worksheet ranges, and make sure each series has a matching set of values and labels. When a sheet has been renamed, Excel often adjusts internal references automatically, but a chart copied from another workbook or edited manually may still need attention.

If the chart shows an incomplete set of observations, check its ending row. A chart based on A2:B20 will not necessarily include data later entered in row 21. Extending the range can solve the immediate problem. For data that grows regularly, converting the source range to an Excel Table can make it easier for a chart to incorporate added rows. Check the chart after adding a test row; do not assume that a chart created from an arbitrary range will expand in every situation.

If a series shows an error or disappears, look for deleted cells, a renamed or deleted worksheet, and references containing #REF!. Rebuild the affected reference from the current sheet rather than trying to guess the old address. Also check whether the source cells contain text where the chart expects numbers, or formulas that currently return errors.

Blank cells and hidden rows can change what appears in a chart without breaking its links. Select the chart and open Chart Design > Select Data, then use Hidden and Empty Cells to review how Excel treats those cells. The available choices depend on the chart and Excel version. This is useful when a line unexpectedly breaks across blanks or values in hidden rows are not appearing as expected.

When the source is another workbook

An external chart reference may include a workbook name and a worksheet name, rather than only a local sheet. If the source workbook has moved, been renamed, or is unavailable, Excel may ask to update links or may be unable to retrieve current values. First confirm that the source file exists and that you have permission to access it. If the file was intentionally moved, use Excel’s workbook-link controls, when available, to locate or update the source, then inspect the chart series again.

Opening a workbook and choosing not to update external links can leave the displayed chart based on saved values rather than fresh source data. That does not necessarily mean the chart’s range is wrong; it means the data may be stale. If you trust the source, update the links and verify the chart. If you do not recognize the source or cannot confirm it is safe and accurate, do not update blindly. A prompt to update is a request to retrieve data, not proof that the linked file is trustworthy.

Be careful with Break Links. Breaking an external workbook link can replace linked formulas with their current values, and it can remove the connection needed to refresh data later. The consequences for a chart depend on how that chart uses the source. Make a separate copy and verify the result before breaking links in a workbook that others rely on.

How to tell whether the chart is now correct

A link can resolve successfully and still point to the wrong data. After repairing it, validate the chart against a few known source cells. Check the first and last plotted points, the series name, and the category labels. For a chart of monthly sales, for example, confirm that the first plotted month is the intended first month and that the last plotted value agrees with the corresponding cell. If the chart has multiple series, verify each one separately.

Then test the behavior that matters. Change a source value in a copy of the workbook and check whether the plotted point changes. Add a row if the data is expected to grow, and see whether the chart includes it. If the chart depends on an external workbook, update the source and confirm that the intended file is being used. Recalculate the workbook with Formulas > Calculate Now if values appear out of date, while remembering that recalculation alone cannot fix an incorrect range or an unavailable source.

On Excel for Mac, the chart concepts are the same, but ribbon labels and the location of workbook-link controls can differ by release. Select the chart and look for the chart-design data-selection controls; if a Windows-specific Workbook Links command is absent, use the Mac version’s available link-management controls or inspect the chart’s series references directly. Excel for the web has more limited editing and link-management capabilities than the desktop app, so opening the file in desktop Excel may be necessary for a detailed repair.

Preventing repeat errors

  • Keep chart data in a clearly labeled table, with one header row and consistent columns.
  • Avoid deleting or moving source columns without checking charts that depend on them.
  • Use meaningful worksheet names and keep external source files in stable, shared locations when possible.
  • When copying a chart between workbooks, inspect its series references afterward; copied charts may retain a connection to the original workbook.
  • Document which source file is authoritative and who is responsible for updating it.
  • Before sending a report, reopen a copy, review any link-update prompt, and compare important chart values with their source cells.

These steps reduce avoidable surprises, but they do not make a workbook self-validating. A chart can remain visually plausible even when it plots an outdated or unintended range. Periodic checks are especially useful for recurring reports, dashboards, and files passed between teams.

Frequently Asked Questions

If Excel says all links are okay, why is my chart blank?

The link check may cover external workbook connections but not whether the chart series points to valid cells. Inspect the chart with Chart Design > Select Data, then check its series references, source values, and whether those cells contain usable data.

How do I find which cells a chart uses?

Select the chart and choose Chart Design > Select Data. Review the chart range and each listed series. Selecting a plotted series can also show its SERIES expression in the formula bar, including the name, label or X-value range, value range, and order.

Why does my chart show old data after I open the workbook?

The workbook may not have updated an external source, or the chart may point to a range that excludes newer data. Confirm the source file and update status, then inspect the chart’s ending row. A saved chart display is not proof that its underlying data is current.

Does fixing a workbook link automatically fix a chart?

Not always. Reconnecting a source can restore access to data, but the chart may still use the wrong series, worksheet, or cell range. After reconnecting, inspect the chart and compare its plotted values with the intended source cells.

Will converting the chart data to an Excel Table fix every linking error?

No. Tables can help charts include rows added to a growing dataset, but they cannot restore a missing external file, correct an incorrect series, or make unsuitable source values meaningful. Convert the data only after checking what the chart currently references.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.