Convert an Excel Chart or Graph into a Data Table
Question details
The user needs a table of values from a chart received for an academic project.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A chart must be converted into a table, but its type and whether its source data is available are unknown.
- Observed behavior
- The desired result is a table containing the chart's underlying values or reasonable estimates if only an image is available.
Check whether you can select individual chart elements in Excel or whether the chart is only an image. If it is editable, check whether the workbook still contains the source worksheet or linked data.
Find the source values of an editable Excel chart
Use this method when the chart is editable and its source data is accessible.
Click the chart in Excel, then choose Chart Design > Select Data. Alternatively, right-click the chart and select Select Data.
In Select Data Source, review the chart data range and select each series to inspect its values and category labels. For an XY scatter chart, check both the X and Y value ranges.
Go to the referenced worksheet cells, then copy the labels and values into a new worksheet or table. Repeat for each series needed for the project.

Digitize a chart image to estimate its data
Use a graph-digitizing tool when the chart is a picture, scan, or other non-editable image.
Recover editable chart data in WPS Spreadsheets
Open an Excel workbook in WPS Spreadsheets and inspect an editable chart's source data to assemble a table. The referenced data must be available; chart images require a separate digitizing tool.
- 1. Open the workbook: Launch WPS Spreadsheets and use Open to select the Excel workbook containing the chart.
- 2. Inspect the chart: Click the editable chart, right-click it, and choose Select Data to inspect its source range and series.
- 3. Find the values: Go to the referenced worksheet cells and identify the labels and values for each series.
- 4. Create the table: Copy the source cells into a new worksheet and arrange the labels and values in columns.

Frequently Asked Questions
How can I tell if a chart is editable?
Click the chart in the workbook. If you can select chart elements and open Chart Design > Select Data, it is an editable chart. A picture usually selects as one object instead.
Can I recover exact values from a screenshot of a graph?
A screenshot does not contain the original data table. A digitizing tool can estimate points after you calibrate the axes, but ask for the source data if exact values are required.
What if the chart references another workbook?
Check the series ranges in Chart Design > Select Data. If they point to an external workbook, open that file or ask its owner to provide the referenced data.
How do I get both X and Y values from a scatter chart?
In Excel, select the chart and open Chart Design > Select Data. Select a series and inspect its X and Y value ranges, then copy both ranges into adjacent table columns.




