Results 1 to 16 of 16

Array Formulas instead of helper columns

Threaded View

  1. #10
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Array Formulas instead of helper columns

    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
    Last edited by ElmerS; 11-21-2009 at 06:25 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1