Incorporating 2 different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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
 
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)
 
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
 
Back
Top