Copy a Data Series Between Charts???

  • Thread starter Thread starter phil6666
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy a Data Series Between Charts??? 1
Decimal point in bar chart and similar 1
HELP! Copy a Data Series to Another Graph? 3
Excel macros graphs work on one laptop, but do not on another. Wh 1
HELP- Copying a Data Series to Another Graph??? 1
Charting the Sum of Two, or More, Series of Data 6
Line charting the same series using data from multiple sheets? 1
Weird issue with very simple line chart - urgent 3

Back
Top