If the chart series now contains actual values rather than links to
ranges/cells you could try the following in order to recoup the data.
Select a series, it's formula should be displayed in the formula bar.
Something like this,
Some you could copy and paste the formula and then extract the values
into cells. Another way to get at the same information would be to use
the Source Data dialog.
If the chart contains many series then you can use some VBA code to
extract those values. If you need help with that post back.
Andy Pope, Microsoft MVP - Excel