Use OFFSET function to define the x-axis range in a chart

[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!


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA