How to save chart

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
 
J

Jon Peltier

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

HenryLon

Jon, I think I found the trick, one has to save it as a workbook, then it is
a freestanding chart file

Henry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 3
How to chart months by financial year 0
Odd Chart Format Results 1
Inside Base Series Label Showing #N/A 0
chart legend changing when I use Select data 1
Chart Location Impact On Links When Copying To New Workbook 1
Embedded Chart Mouse Hover Difference - XL2007 vs XL2003 3
Not plot a data series in a chart but still display in data table 1

Top