How to save chart

  • Thread starter Thread starter HenryLon
  • Start date Start date
H

HenryLon

Do not use the chart feature regularly

Have a simple time series I want to chart
When I set the chart using the wizard all works fine
When I am asked what location I want I do not use the embedded option so I
name the chart

But then the underlying data file disappears!

Where is the trick because the new chart seems to overwrite the basic data
file, in effect wiping out the information

tks

Henry
 
Henry -

Does the chart still show the correct data plotted? Or does it reflect
the fact that the data is missing? Has the sheet with the data
disappeared? No sheet tab where it ought to be?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon, I think I found the trick, one has to save it as a workbook, then it is
a freestanding chart file

Henry
 
Back
Top