If you’ve ever stared at an Excel chart and wished you could get the exact numbers behind the plotted lines, bars, or pie slices, this list is for you. Whether you’re a student trying to reconstruct a dataset, an analyst recovering figures from a shared report, or a professional working with legacy charts, these ten methods will help you pull raw data out of a graph—some without any manual transcription. Each approach has its own strengths, so you can pick the one that fits your situation.
1. Use the Chart’s Built-In Data Table
Excel can display the underlying values directly on the chart. Right-click the chart, choose ‘Add Data Table,’ and select ‘Show Data Table’ or ‘Show Data Table with Legend Keys.’ This places a small grid beneath the chart showing the x and y values for each plotted point. It’s the quickest way to visually copy numbers, but it only works if the chart still has its source data linked—if the link is broken, the table won’t appear.
2. Click the Chart and Look at the Formula Bar
When you click on a data series in a chart, the formula bar shows the SERIES formula, like =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1). This formula reveals the exact cell ranges that feed the chart. You can then navigate to those cells and copy the data directly. This is a manual but reliable method, especially when the chart is on a different sheet and you need to trace back to the original source.
3. Export Chart Data to a New Sheet
If the chart is embedded in a worksheet, you can copy the chart and paste it into a new sheet as a picture, but that doesn’t give you data. Instead, right-click the chart, select ‘Select Data,’ and click ‘Switch Row/Column’—this doesn’t extract data, but it can help you understand the structure. For a true export, use the ‘Copy’ and ‘Paste Special’ options: copy the chart, then paste as a linked picture or as a bitmap—neither gives data. The real trick is to use the ‘Select Data’ dialog to see the ranges and then manually copy those ranges to a new location. It’s not automated, but it’s straightforward.
4. Use the ‘Select Data’ Dialog to View Series Values
Right-click the chart and choose ‘Select Data.’ In the dialog box, click on any series in the left panel, then click ‘Edit’ to see the ‘Series values’ field, which lists the cell range for the y-values. You can also see the ‘Series name’ and ‘Category (X) axis labels’ ranges. This gives you a clear map of where every piece of data lives. From there, you can go to those cells and copy the numbers. This is a manual but precise way to identify the exact source cells.
5. Use the ‘Chart Tools’ > ‘Design’ > ‘Select Data’ Ribbon
On the ribbon, under ‘Chart Tools’ > ‘Design,’ there’s a ‘Select Data’ button that opens the same dialog as above. This is just a different path to the same information. However, it’s worth noting that if the chart is on a separate chart sheet, the ribbon still works the same way. This method is useful when you’re already in the ribbon and want to quickly check the data ranges without right-clicking.
6. Use VBA to Extract Data from a Chart
If you’re comfortable with a little code, you can use a simple VBA macro to loop through each series in a chart and output the values to a worksheet. For example, you can write a macro that opens the chart’s SeriesCollection, reads the .Values and .XValues properties, and writes them to cells. This is a powerful method for charts with multiple series or when you need to automate the extraction for many charts. It requires enabling the Developer tab and trusting the macro, but it’s a one-time setup that saves hours of manual copying.
7. Use a Third-Party Add-In or Tool
Several add-ins, like ‘Chart Data Extractor’ or ‘Excel Chart Data Recovery,’ can pull data from charts even if the source data is missing. These tools often work by reading the chart’s internal XML or by using the chart’s cached data. Some are free, others are paid. If you frequently work with charts that have lost their source data, investing in a reliable add-in can be a lifesaver. Always download from reputable sources and check compatibility with your Excel version.
8. Copy the Chart and Paste into a Graphics Editor
This doesn’t extract data, but it’s a workaround if you only need approximate values. Copy the chart and paste it into an image editor like Paint or Photoshop. Then, you can use the ruler or pixel coordinates to estimate the values based on the axis labels. This is extremely manual and imprecise, but it works when no other method is available—for example, if the chart is a screenshot with no underlying file. It’s best used as a last resort.
9. Use OCR with a Chart Image
If you have a chart as an image (e.g., from a PDF or a screenshot), you can use Optical Character Recognition (OCR) software to read the axis labels and data labels. Tools like Tesseract or online OCR services can extract text, but they won’t give you the plotted values unless the chart has data labels displayed. If the chart has labels on each point, OCR can capture those numbers. This is helpful for charts that are only available as images, but it requires that the labels are visible and legible.
10. Recreate the Chart from the Image Manually
When all else fails, you can manually read the approximate values from the chart’s gridlines and axis ticks. For a line chart, estimate the y-value for each x-point by seeing where the line crosses the gridlines. For a bar chart, read the value from the top of each bar against the axis scale. This is tedious but can be accurate enough for rough analysis. Use the axis intervals to estimate values to the nearest gridline division. This method is time-consuming, so only use it for small datasets.
How to Choose
The best method depends on whether the chart still has its source data linked. If yes, the quickest is to use the ‘Select Data’ dialog to find the ranges and then copy them—no coding needed. If the source data is gone but the chart is still in the file, VBA or a third-party add-in can recover the cached data. If you only have an image, OCR or manual estimation are your only options, but they’re less accurate. For frequent work, learn VBA—it’s the most flexible and can handle multiple charts at once.
Frequently Asked Questions
Can I extract data from a chart if the source data is deleted? Yes, if the chart is still in the workbook, the cached data is often still there. You can use VBA to read the series values, or try a third-party add-in. If the chart is just an image, you cannot extract exact data.
Why does the ‘Select Data’ dialog show a different range than expected? Sometimes Excel stores a reference to a range that has been moved or renamed. Check if the range is valid and if it points to the correct sheet. If the range is invalid, the chart may show an error, and you’ll need to fix the reference.
Is there a way to export chart data to a CSV file? Not directly. Excel doesn’t have a built-in ‘Export Chart Data’ button. You can copy the data from the source cells and paste into a CSV, or use a VBA macro to write the chart values to a CSV file.
Can I extract data from a chart in Google Sheets? This article focuses on Excel, but Google Sheets has similar features. You can click on a chart and use the ‘Advanced edit’ to see the data range, or use the ‘Chart data’ panel to view the source. There’s also a Google Sheets script that can extract chart data, but it’s less straightforward.
What if the chart has multiple series? The same methods apply. In the ‘Select Data’ dialog, you’ll see each series listed. You can copy the ranges for each series individually. VBA can loop through all series and extract them all at once.
Does this work for all chart types? Yes, the methods work for most chart types, including line, bar, column, and pie charts. For pie charts, the data is usually in one series, and the categories are the x-labels. The same techniques apply.
Final Thoughts
Extracting data from an Excel graph is often easier than you think, especially if the chart is still linked to its source. Start with the simple methods like the ‘Select Data’ dialog, and move to VBA or add-ins only if you need to automate or recover lost data. For images, OCR or manual estimation are your fallback. With these ten approaches, you’ll rarely be stuck staring at a chart without the numbers behind it.