Thanks,
I figured out the abs. ref. before reading your last response - however.
I named the first formula as: BUY and the second as: SELL
(did not forget to erase the -1)
If I type in a cell: =BUY >> selecting it within the formula bar >> pressing F9 - I get this which is fine:
{1;"";3;"";"";"";"";"";7;"";"";"";13;"";12;"";20;"";"";"";"";22;""}
When doing the same for =SELL - I get:
{"";5;"";"";"";6;"";"";"";"";"";15;"";14;"";"";"";"";"";"";"";"";""} which is also as expected.
However:
I did not succeed using the name BUY as the values for series1 and SELL as the values for series2.
maybe because it is a result of an array formula ?
If I name the range B2:B24 as BUY and C2:C24 as SELL - I can use it as the series source.
What did I do wrong ?
Elm
=================== added ======================
I named the first array formula as BUY and the range B2:B24 as BBB
I declared a small line chart and changed in the formula bar from: =SERIES(,,Book3.xls!B2:B24,1) to: =SERIES(,,Book3.xls!BBB,1)
This works graet.
However - when I change the series into: =SERIES(,,Book3.xls!BUY,1) the chart becomes all zeros.
When I select, in the formula bar, the part: Book3.xls!BBB and hit F9 I get {1;"";3;"";"";"";"";"";7;"";"";"";13;"";12;"";20;"";"";"";"";22;""}
When I do the same to: Book3.xls!BUY I get: {"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";""}
Well I hope my problem is now fully understood.
Thanks in advance for any assistance.
Elm
Bookmarks