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
 

flk here
"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
 

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/ChartsH...ChartData.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
_______


"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
 

How do I unlink the chart??
"Jon Peltier" wrote in message
...
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/ChartsH...ChartData.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
_______


"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
 

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

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


"FLKulchar" wrote in message
...
How do I unlink the chart??
"Jon Peltier" wrote in message
...
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/ChartsH...ChartData.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
_______


"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
 

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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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" wrote in message
...
In the web page I cited, scroll down a screen or two to the section
entitled "Unlink the Chart Series from Worksheet Data".

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


"FLKulchar" wrote in message
...
How do I unlink the chart??
"Jon Peltier" wrote in message
...
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/ChartsH...ChartData.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
_______


"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
 

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

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


"F. Lawrence Kulchar" wrote in
message ...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu Copy
(or control C).

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


"F. Lawrence Kulchar" wrote
in message ...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar" wrote
in message ...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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" wrote in message
...
No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar" wrote
in message ...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FLKulchar" wrote in message
...
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" wrote in message
...
No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar"
wrote in message
...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FLKulchar" wrote in message
...
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" wrote in message
...
No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar"
wrote in message
...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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

FLKulchar
"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FLKulchar" wrote in message
...
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" wrote in message
...
No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar"
wrote in message
...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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
 

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

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


"FLKulchar" wrote in message
...

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FLKulchar" wrote in message
...
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" wrote in message
...
No.

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


"FLKulchar" wrote in message
...
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" wrote in message
...
Select the chart, not the cells under the chart, then use Edit menu
Copy (or control C).

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


"F. Lawrence Kulchar"
wrote in message
...
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
"Jon Peltier" wrote:

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/ChartsH...ChartData.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
_______


"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