Copy a Data Series Between Graphs???

[phil6666]

Hi-

I'm using Excel 2002 and I've got a lot of graphs, all of which are
based on a common spreadsheet, which require the regular movement of
data series between the graphs.

It would be wonderful if there was a simple way to cut & paste or copy
these data series between the graphs.

Can it be done?


Someone asked for more specific info...here it is:

I have a spreadsheet that shows data for all 50 states.

I have about 10 graphs which show this data, but only for certain
states. (All graphs are very similar, except for which states are on
which graph.)

Graph #1 might have NY and 9 other states.

Graph #2 might have NC and 9 other states.

After a month, I might have to move NY to graph #2 and NC to graph #1.

Is there a way to copy/paste the "data series" for NY to move it to
graph #2?

thnx

 

[duane]

2 solutions

1) it is very easy to select the data for your series and past
spaceial in a chart as a new series - this leaves you with defaul
formatting though.

2) you can also easily just edit the series on the chart - sounds lik
you just need to change the column or row reference to change states
this preserves formatting