Incorporating 2 different worksheets
 

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
--
miteeka

Incorporating 2 different worksheets
 

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" wrote:

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
--
miteeka

Incorporating 2 different worksheets
 

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
--
miteeka


"john" wrote:

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" wrote:

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
--
miteeka

Incorporating 2 different worksheets
 

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)


"miteeka" wrote:

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
--
miteeka


"john" wrote:

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" wrote:

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
--
miteeka

Incorporating 2 different worksheets
 

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

"miteeka" wrote in message
...
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
--
miteeka

Incorporating 2 different worksheets
 

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


--
miteeka


"john" wrote:

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)


"miteeka" wrote:

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
--
miteeka


"john" wrote:

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" wrote:

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
--
miteeka

Incorporating 2 different worksheets
 

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

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"miteeka" wrote in message
...
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
--
miteeka


"john" wrote:

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" wrote:

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
--
miteeka