Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |