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

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.)

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

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.


Martin63 Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487486

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

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.

"Bryan Hessey" wrote:


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.


Martin63 Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487486

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

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/
_______


"Martin63" wrote in message
...
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.)