ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving a Chart (https://www.excelbanter.com/excel-programming/399694-saving-chart.html)

F. Lawrence Kulchar

Saving a Chart
 
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

Nigel[_2_]

Saving a Chart
 
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



joel

Saving a Chart
 
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


Jon Peltier

Saving a Chart
 
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





All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com