Carim  thanks for the suggestion, but I've unfortunately already tried using a named range, and it still didn't work.
Posts by babr1477


I am trying to create a chart using this formula for the XAxis 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 Xaxis points
 $J$2 contains the row number of the first Xvalue 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 XAxis
If I enter this formula into a cell, it will evaluate to a 1row 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 XAxis. 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!