Chart & Visualization Issues

How to Extract X and Y Data From an Excel Chart Without Source Data

Bushra Parveen Sep 27, 2026 869 views

Question details

The user needs to recover or extract the X and Y coordinates from an existing Excel chart where the original source data is missing, hidden, or inaccessible.

How to Extract X and Y Data From an Excel Chart Without Source Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to retrieve raw data points from a chart for further analysis or backup when the original dataset has been lost or deleted.
Observed behavior: The chart is visible, but the underlying data table is missing or disconnected, making it difficult to view or extract the exact X and Y values.

Before you start

Click on the chart to determine if it is a live, embedded Excel object (which will display Chart Tools in the ribbon) or simply a static image pasted into the spreadsheet.

Solution 1Recommended

Extract Data from an Embedded Live Chart

Use this method if the chart is still a live Excel object, as the X and Y data might be cached or hidden directly within the workbook.

When an Excel chart is created, it often caches the source data even if the original visible cells are deleted. By accessing the chart's internal data selection menu, you can frequently view or retrieve this embedded information.

Select the Chart

Open your spreadsheet and right-click on the chart from which you want to extract the data.

Access Data Selection

From the context menu, select 'Edit Data' or 'Select Data'. This will attempt to open the cached data range or display the specific series formulas.

Inspect and Copy Data

If the data table appears, highlight the X and Y columns, right-click to select 'Copy', and paste them into a new, safe worksheet.

Extract Data from an Embedded Live Chart

External Link Errors: If clicking 'Edit Data' results in an error, the chart may be linked to an external workbook that has been moved or deleted, meaning the data is no longer cached locally.

Solution 2

Extract Data Using a Chart Digitizing Tool

If your chart is a static image or a completely severed object, you cannot extract the data natively and must digitize the image.

Easily Manage and Extract Chart Data in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools to handle data visualizations, ensuring your source data and charts are always seamlessly linked. You can easily select, edit, and recover embedded chart data with just a few clicks.

1. Open Your File in WPS: Launch WPS Spreadsheet and open the document containing your chart.
2. Activate Chart Tools: Click directly on the chart to reveal the 'Chart Tools' menu on the top ribbon.
3. Edit Chart Data: Click the 'Edit Data' button to automatically open and display the source data range associated with the chart's X and Y values.
4. Secure Your Data: Select the revealed data cells, copy them, and paste them into a new sheet to ensure your recovered data is safely backed up.

Seamlessly edit, select, and recover embedded chart data100% compatible with Microsoft Excel (.xls, .xlsx) formatsLightweight, fast performance, and completely free to useIntuitive user interface for quicker data analysis

microsoft office alternative - wps office

Frequently Asked Questions

Can I recover deleted source data if I only have the chart?

Yes, if the chart is a live object. Excel often caches the data in the background. Right-clicking the chart and selecting 'Edit Data' can frequently restore or display the cached values.

Why does clicking 'Select Data' show an error message?

This typically happens if the chart's source data was stored in an external workbook that has since been moved, renamed, or deleted, breaking the link and preventing the software from retrieving the data.

Are there automated tools to extract data from a chart image?

Yes, tools like WebPlotDigitizer allow you to upload an image of a graph, calibrate the X and Y axes, and automatically or manually extract the coordinates to a CSV file.

Excel & Data Problems