Excel XP. Get access to data in a chart.

**leo-samba** · 06-19-2011, 02:35 PM

Hi, people.
Can you please suggest a way to access data in a chart (Excel XP), for which a source file is absent.
The goal is to save the data in a spreadsheet or text format.
Thank you.

**teylyn** · 06-19-2011, 06:50 PM

Hello,

what do you mean with "the source file is absent"? If the source is a linked file, you can break the link and then inspect the series formula for each data series. The data will then be hard-coded in the series formula.

cheers,