Chart Axis Label according to 2 cell values

My horizontal axis label is currently ='S-CURVES LVL1'!$F$9:$BG$9

I want the $F$9 & $BG$9 to refer to another cell

something like this

='S-CURVES LVL1'!"Range("G53").Value":"Range("H53").Value"

What is the contents of G53 and H53?

I would think there would be a way to do this using the INDIRECT function, but couldn't come up with it. Searching the internet, it seems that it's possible, but I couldn't find any results that actually worked, or that provide a clear step-by-step way to set it up. Maybe someone else smarter than me can step in.

Using INDIRECT in the named range causes the chart to report error with formula.
If you can use a few helper cells to get the row/column position and size then you can use named ranges.

That does work! But I'm still not seeing how. The chart data range formula points to the data, not to the cells with your INDIRECT formulas. How does it know to adjust the range when you change the start/finish values?

The chart series references 2 named ranges, as can be seen in the series formula

=SERIES(,'1051472.xlsx'!LABS,'1051472.xlsx'!DATA,1)

The named range LABS
=OFFSET(Sheet1!$A$1,Sheet1!$G$3-1,Sheet1!$H$3-1,Sheet1!$G$4-Sheet1!$G$3+1,Sheet1!$H$4-Sheet1!$H$3+1)

is the one that locates the start position and range size by using the row/column information from the sheet.

The named range DATA is simply the range to the immediate right of LABS.
=OFFSET(LABS,0,1)

I could not get a named ranged formula that included INDIRECT in the chain to work within the chart.

I see. You have to look at the individual series values to see the indirect cell references. I was just looking at the Chart Data Range, which shows the full actual range.

Thanks.