Posts by babr1477

    I am trying to create a chart using this formula for the X-Axis section of the SERIES formula:
    =OFFSET(INDIRECT("Sheet1!"&ADDRESS(Sheet1!$J$2,3)),0,0,Sheet1!$K$2,1)

    • Column C on my worksheet contains the week's worth of X-axis points
    • $J$2 contains the row number of the first X-value for this particular chart (it's one of 8 to be drawn from the same data)
    • $K$2 contains the number of rows to include in this particular chart's X-Axis

    If I enter this formula into a cell, it will evaluate to a 1-row array with the correct values.
    If I use this function in a SERIES function, I get an error message that says: "that function is not valid."


    I would really appreciate it if someone could explain why my formula isn't working, and how to correct it.


    I went back to some earlier projects where I'd successfully used an OFFSET function to define the X-Axis. I noticed that none of them used a formula for the first parameter of OFFSET, and none included an INDIRECT function or an ADDRESS function. Could one of these 3 differences explain things?


    Thanks for your help!