Saving a Chart

[F. Lawrence Kulchar]

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]

flk here

 

[Jon Peltier]

Looks like your caps lock button is stuck.

You can:

1. copy the sheet that contains the chart and its data, so you maintain a
live historical chart (connected to real data) and add data to the copied
sheet.

2. copy the chart and unlink it from the data:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

3. copy a picture of the chart (hold shift, select the Edit menu, use Copy
Picture, select the On Screen and Picture options) and paste it in the
sheet.

- Jon

 

[FLKulchar]

How do I unlink the chart??

Looks like your caps lock button is stuck.

You can:

1. copy the sheet that contains the chart and its data, so you maintain a
live historical chart (connected to real data) and add data to the copied
sheet.

2. copy the chart and unlink it from the data:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

3. copy a picture of the chart (hold shift, select the Edit menu, use Copy
Picture, select the On Screen and Picture options) and paste it in the
sheet.

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

 

[Jon Peltier]

In the web page I cited, scroll down a screen or two to the section entitled
"Unlink the Chart Series from Worksheet Data".

- Jon

 

[F. Lawrence Kulchar]

Mr. Peltier:
Thank you for all the help...however, I am having trouble "unlinking a chart".

I, first, copy the chart by highlighting the cells around it, and press Ctrl
C...

then, i click on the series, go to the formula bar, click, and press f9...

I get the data values of my series...

then if i hit Ctrl V in another workbook, I do NOT get a copy...

rather, just the un-ability to paste!!

PLS ADVISE:

thanks, FLKulchar

 

[FLKulchar]

i did that...as mentioned in my post...

for some reason, I am not able to paste the chart...unlinked...in a new
workbook

 

[Jon Peltier]

Select the chart, not the cells under the chart, then use Edit menu > Copy
(or control C).

- Jon

 

[FLKulchar]

Jon:

When a chart becomes delinked, should I end up with a chart that appears
"blank", i.e. no data in it??

FLKulchar

 

[Jon Peltier]

No.

- Jon

 

[FLKulchar]

well, then, in that case, in spite of following all your sound advice, I
seem to be having trouble unlinking a chart...once I copy the chart, and
then F9 the formula bar, etc. (wind up with referenced data instead of range
references), I cannot paste the "unlinked" chart..

Thanks,
FLKulchar

 

[Jon Peltier]

Okay, I'll bite. If you zip up your workbook and send it to me, I'll see if
I can make it work.

- Jon

 

[FLKulchar]

IO attached a file to other email...THANK YOU for your patience!

FLKulchar

 

[Jon Peltier]

I've sent a workbook and an image file under separate cover, to try to
illustrate the protocol.

- Jon