How do i recover data in a worksheet that is still in a chart?

[Guest]

I inadvertently deleted a column of data from an Excel worksheet. A chart of
these data is still present, and is properly plotted. Is there a way to
recover the data? (The Excel file must store the data somewhere if it still
appears in a chart.)

 

[Bryan Hessey]

If you right-mouse the Chart, does it have a 'Source Data' option, and
if so, what range does that point to. That should be your data.

 

[Guest]

When I select the "Source Data" option, the "Y-Values" box contains a "#REF!"
error. I deleted the column of data that this box originally pointed to, but
that data still appear plotted in the chart. Since it appears in the chart,
the Excel file must still contain the deleted data, even though it no longer
appears on the worksheet.

 

[Jon Peltier]

The procedure in this page works in Excel 97 through 2003:

http://support.microsoft.com/?kbid=213814

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______