Copy a Data Series Between Charts???

P

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?

thnx
 
T

Tushar Mehta

phil6666 said:
based on a common spreadsheet, which require the regular movement of
data series between the graphs.
Click to expand...
What does "movement of data series between the graphs" mean?
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
P

phil6666

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
 
Top