| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
