Incorporating 2 different worksheets

[miteeka]

Could I get help in incorporating data from 2 different worksheets into one
graph. Does anyone know if this is even possible. I've tried holding CTRL and
selecting another worksheet but Excel won't let me. Is there a manual way to
type in the cell ranges? Thanks

 

[john]

Try doing the graph for the first sheet, then copy the data on the second
sheet and paste it onto the chart
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[miteeka]

Hi John,

I tried doing this and it creates a new series for me. I want the data from
the second worksheet to be continuous with the first in only 1 series. Thanks

 

[john]

Do you get a pop up dialogue box when you paste the information onto the
chart - try using the paste special option under the edit menu
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[David Biddulph]

Once you've got one graph, Chart menu/ Source Data ...

 

[miteeka]

I don't get a pop-up box, all it does is automatically insert a new series
into the graph. Unfortunately the paste special doesn't work

 

[Jon Peltier]

You cannot combine data from two sheets into a single series, unless you
combine them in a single worksheet first.

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon