| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I use data from 2 separate worksheets in one chart?
Both worksheets are in the same workbook.
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Hi,
What version of Excel are you using: In 2003 and earlier in the Chart Wizard in the Data range box on step 2, highlight one of the ranges, then hold down the Ctrl key and highlight the other range. -- Cheers, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Both ranges highlighted in this way must be on the same worksheet.
You can use data from different sheets in the same chart, but the X values or Y values within a single series cannot be split over multiple worksheets. You could construct a summary table linking to the separate sheets. This page gives more details: - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi, What version of Excel are you using: In 2003 and earlier in the Chart Wizard in the Data range box on step 2, highlight one of the ranges, then hold down the Ctrl key and highlight the other range. -- Cheers, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Hi Jon,
Don't forget the page: ? -- Cheers, Shane Devenshire "Jon Peltier" wrote: Both ranges highlighted in this way must be on the same worksheet. You can use data from different sheets in the same chart, but the X values or Y values within a single series cannot be split over multiple worksheets. You could construct a summary table linking to the separate sheets. This page gives more details: - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi, What version of Excel are you using: In 2003 and earlier in the Chart Wizard in the Data range box on step 2, highlight one of the ranges, then hold down the Ctrl key and highlight the other range. -- Cheers, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Doh!!
Here's the link I forgot: http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, Don't forget the page: ? -- Cheers, Shane Devenshire "Jon Peltier" wrote: Both ranges highlighted in this way must be on the same worksheet. You can use data from different sheets in the same chart, but the X values or Y values within a single series cannot be split over multiple worksheets. You could construct a summary table linking to the separate sheets. This page gives more details: - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi, What version of Excel are you using: In 2003 and earlier in the Chart Wizard in the Data range box on step 2, highlight one of the ranges, then hold down the Ctrl key and highlight the other range. -- Cheers, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Hi Skeety,
If the data is on different sheets you can use the Series tab of the 2nd step of the Chart Wizard to specify each of the ranges one at a time. These ranges can even be in different workbooks. I didn't check out the site Jon recommended yet. -- Thanks, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Thanks Shane - my chart looks lovely now!
"ShaneDevenshire" wrote: Hi Skeety, If the data is on different sheets you can use the Series tab of the 2nd step of the Chart Wizard to specify each of the ranges one at a time. These ranges can even be in different workbooks. I didn't check out the site Jon recommended yet. -- Thanks, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I use data from 2 separate worksheets in one chart?
Hi Jon, thanks for the info, I now have a highly informative chart to share
with my colleagues! "Jon Peltier" wrote: Doh!! Here's the link I forgot: http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, Don't forget the page: ? -- Cheers, Shane Devenshire "Jon Peltier" wrote: Both ranges highlighted in this way must be on the same worksheet. You can use data from different sheets in the same chart, but the X values or Y values within a single series cannot be split over multiple worksheets. You could construct a summary table linking to the separate sheets. This page gives more details: - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi, What version of Excel are you using: In 2003 and earlier in the Chart Wizard in the Data range box on step 2, highlight one of the ranges, then hold down the Ctrl key and highlight the other range. -- Cheers, Shane Devenshire "Skeety" wrote: Both worksheets are in the same workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ... I want to chart data from 30 separate worksheets ... | Excel Discussion (Misc queries) | |||
| Compare Data in two Separate Worksheets | Excel Discussion (Misc queries) | |||
| Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
| Compare data on 2 separate worksheets. | Excel Worksheet Functions | |||
| need help comparing data in 2 separate worksheets | Excel Worksheet Functions | |||
Linear Mode
