Suppose I have a chart with, for example, data in it as follows (source data):

A1:A20

Every so often, I REWRITE over that same range new data...and create a new
chart!!

HOW CAN I SAVE MY PRE-EXISTING CHART, i.e. WITH THE OLD DATA??

Thanks,
flkulchar

Hi flkulchar

One way would be to copy chart and paste-special as a image, I use GIF as it
works well for me.

--

Regards,
Nigel




"F. Lawrence Kulchar" wrote in
message ...
Suppose I have a chart with, for example, data in it as follows (source
data):

A1:A20

Every so often, I REWRITE over that same range new data...and create a new
chart!!

HOW CAN I SAVE MY PRE-EXISTING CHART, i.e. WITH THE OLD DATA??

Thanks,
flkulchar

The best way is to copy the worksheet to a new worksheet by right clicking
the tab on the bottom of the worksheet and make a copy. Then rename the new
worksheet to abc backup or some other name.

"F. Lawrence Kulchar" wrote:

Suppose I have a chart with, for example, data in it as follows (source data):

A1:A20

Every so often, I REWRITE over that same range new data...and create a new
chart!!

HOW CAN I SAVE MY PRE-EXISTING CHART, i.e. WITH THE OLD DATA??

Thanks,
flkulchar

You keep asking this question. Don't you like any of the responses you've
received?

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


"F. Lawrence Kulchar" wrote in
message ...
Suppose I have a chart with, for example, data in it as follows (source
data):

A1:A20

Every so often, I REWRITE over that same range new data...and create a new
chart!!

HOW CAN I SAVE MY PRE-EXISTING CHART, i.e. WITH THE OLD DATA??

Thanks,
flkulchar