View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shooter Shooter is offline
external usenet poster
 
Posts: 11
Default 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