duplicate series in a graph?

[cmendes]

Hello all,

I have a sheet with a ton of data and in the same sheet I have 25 graphs.
Currently there are two series of xy in each graph.
I want to add another series to all of these graphs, the way i know is to go graph by graph and add a new series and set the x and y fields.
Is there a better way to do this??? I though i could duplicate one of the series and then select this new series and drag the new fields.
Any suggestions?
Thanks in advance,
Cesar

 

[Steve=True]

Not sure if easier, but select the data, then copy, then

select chart

then go to the home ribbon (2007) and select Paste Special

A dialog box will open up.

Select your choices and click okay.