Chart & Visualization Issues

How to Export Excel Chart Series Values Without Source Data

Huda Qurayshi Oct 20, 2026 868 views

Question details

The user needs to extract or export series values that are embedded in an Excel chart when the original source data worksheet or file is missing or deleted.

How to Export Excel Chart Series Values Without Source Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to recover chart data values after the original source data has been lost, deleted, or disconnected.
Observed behavior: Excel retains the chart visuals and embedded series values, but lacks a built-in standard tool to automatically export these embedded values back into a worksheet.

Before you start

Before attempting to extract embedded values, verify that the source data is not simply located in a hidden worksheet or linked to an external workbook that can be recovered.

Solution 1Recommended

Use a VBA Macro to Extract Chart Values

Since Excel lacks a built-in feature for this, running a VBA script is the most efficient way to loop through charts and extract the embedded array values.

A VBA script can read the internal properties of a chart object, specifically the .Values and .XValues arrays, and write them directly into a blank worksheet.

Open the VBA Editor

Press ALT + F11 on your keyboard to launch the Microsoft Visual Basic for Applications editor.

Insert a New Module

Click on 'Insert' in the top menu, then select 'Module' to create a blank script window.

Add the Extraction Code

Write or paste a VBA macro designed to target the ActiveChart.SeriesCollection object, assigning the embedded .XValues and .Values to a specific worksheet range.

Run the Macro

Select the chart you want to extract data from, return to the VBA editor, and press F5 to execute the script and output the data.

Automation Advantage: VBA scripts can be customized to process multiple charts and worksheets simultaneously, saving significant manual effort.

Solution 2

Manually Extract Values via Select Data

For a single chart with very few data points, you can manually view and copy the embedded arrays from the chart's properties.

Solution 3

Submit a Feature Request to Microsoft

If you frequently encounter this issue, providing feedback can help Microsoft prioritize adding a native data extraction tool in future Excel updates.

Free Microsoft Office alternative

Try WPS Office for Powerful Data Visualization and Compatibility

While extracting lost source data from charts can be complex, maintaining and backing up your spreadsheets doesn't have to be. WPS Office offers a robust, highly compatible spreadsheet tool that perfectly supports Microsoft Excel formats, preventing data loss with advanced auto-saving and cloud sync features.

Fully compatible with Microsoft Excel (.xlsx, .xls) and standard chart formats.Free, lightweight, and incredibly easy to navigate.Built-in cloud synchronization to securely back up your original source data.Intuitive chart creation and advanced data visualization tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart still display correctly after the source data is deleted?

Excel caches the series values directly inside the chart object's properties. Because these values become hardcoded into the chart's memory, the visual representation remains intact even if the external link or source sheet is broken.

Can I use Power Query to extract embedded chart data?

No, Power Query is designed to extract and transform data from tables, ranges, or external databases. It cannot read properties or arrays embedded directly inside a graphical chart object.

Are there any third-party add-ins that can recover this chart data?

Yes, there are several specialized Excel add-ins available online, often referred to as 'Chart Data Extractors'. These are designed specifically to read chart objects and recover the underlying arrays when the source data is lost.

Excel & Data Problems