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

M

Martin63

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

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

Martin63

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