Chart & Visualization Issues

Convert an Excel Chart or Graph into a Data Table

Steve KSteve K Nov 18, 2026 869 views

Question details

The user needs a table of values from a chart received for an academic project.

How to Convert an Excel Chart or Graph into a Data Table
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.
Before you start

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.

Solution 1Recommended

Find the source values of an editable Excel chart

Use this method when the chart is editable and its source data is accessible.

1
Open the chart data settings

Click the chart in Excel, then choose Chart Design > Select Data. Alternatively, right-click the chart and select Select Data.

2
Identify the source ranges

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.

3
Build the table

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.

Find the source values of an editable Excel chart
Source data may be unavailable: A chart can reference another workbook or data that is no longer accessible. Ask for the source file if the referenced values cannot be opened.
Work with chart data in WPS

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. 1. Open the workbook: Launch WPS Spreadsheets and use Open to select the Excel workbook containing the chart.
  2. 2. Inspect the chart: Click the editable chart, right-click it, and choose Select Data to inspect its source range and series.
  3. 3. Find the values: Go to the referenced worksheet cells and identify the labels and values for each series.
  4. 4. Create the table: Copy the source cells into a new worksheet and arrange the labels and values in columns.
Inspect chart series and source ranges in a spreadsheetOpen and edit Microsoft Excel XLSX and XLS filesCopy available chart values into a separate tableUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.