ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   SAVING AND REWRITING CHARTS (https://www.excelbanter.com/charts-charting-excel/162899-saving-rewriting-charts.html)

F. Lawrence Kulchar

SAVING AND REWRITING CHARTS
 
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

Andy Pope

SAVING AND REWRITING CHARTS
 
Hi,

See Jon's page for information on de-linking chart from data.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

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


FLKulchar

SAVING AND REWRITING CHARTS
 
Thank you...
it works!!
"Andy Pope" wrote in message
...
Hi,

See Jon's page for information on de-linking chart from data.
http://peltiertech.com/Excel/ChartsH...ChartData.html

Cheers
Andy

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





All times are GMT +1. The time now is 03:04 AM.

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