Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
charts with data from two worksheets
I have set up a stock chart with 3 series, high, low and close.
The data is from two worksheets. My existing series1 is =sheet1!$b$10:$x$10. I would like to include the following data from sheet 2 to the same chart- =sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of data above but it will not take it. Do you know what I am doing wrong? I have also tried copying the row from sheet 2 and pasting to the series in sheet one but it doesn't seem to work. Thanks for your assistance. -- Shooter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
charts with data from two worksheets
Separate the data with a comma, not a + or a colon.
You may find it easier to copy the data, then go to the chart, and Edit/ Paste special, and follow the prompts for adding a new series, or new points to the existing series. -- David Biddulph "Shooter" wrote in message ... I have set up a stock chart with 3 series, high, low and close. The data is from two worksheets. My existing series1 is =sheet1!$b$10:$x$10. I would like to include the following data from sheet 2 to the same chart- =sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of data above but it will not take it. Do you know what I am doing wrong? I have also tried copying the row from sheet 2 and pasting to the series in sheet one but it doesn't seem to work. Thanks for your assistance. -- Shooter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
charts with data from two worksheets
You can't combine data from multiple sheets into the X or Y values of a
single series. You could copy the data and paste it as a new series, but not as new points. Here's more about charting data from different sheets: http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "David Biddulph" wrote in message ... Separate the data with a comma, not a + or a colon. You may find it easier to copy the data, then go to the chart, and Edit/ Paste special, and follow the prompts for adding a new series, or new points to the existing series. -- David Biddulph "Shooter" wrote in message ... I have set up a stock chart with 3 series, high, low and close. The data is from two worksheets. My existing series1 is =sheet1!$b$10:$x$10. I would like to include the following data from sheet 2 to the same chart- =sheet2!$b$10:$x$10. I have tried putting + or : between the two sets of data above but it will not take it. Do you know what I am doing wrong? I have also tried copying the row from sheet 2 and pasting to the series in sheet one but it doesn't seem to work. Thanks for your assistance. -- Shooter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying charts and their data with relative cell positions | Charts and Charting in Excel | |||
Consolidate Several Workbooks into One | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) |