Copy a Data Series Between Charts???

[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

 

[Debra Dalgleish]

Select a series in one chart, and you'll see its formula in the formula bar
Highlight the formula and copy it.
Press the Enter key, or Esc key, to exit the formula

Select the other chart
Click in the Formula bar, and Paste.