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