How to get a chart range from OFFSET?

[KungPaoDog]

I have X values in A1:A20
I have Y values in B1:B20

I want to chart A6:A16 for X and B6:B16 for Y using":
OFFSET(A1,5,0,10,2)
-or-
OFFSET(A1,5,0,10,1) for X values
-and-
OFFSET(B1,5,0,10,1) for Y values

I have tried to "define name" for these formulas, but I still can't make the chart display what I want. I even had the curve displayed once, but it disappeared after I clicked away an error.

This is the basic version of what I am trying to accomplish. It will fit in to the rest of my sheet if I can make this work, and yes, I know there are easier ways to chart what I have stated above.

I'll happily post up my sample sheet if someone can tell me how. Thanks for any help.

 

[SydneyGeek]

When you click on the Series formula, the bit with the hard-wired range needs to be replaced with something like:
'Worksheet name!NamedRange'

If you just put in the named range, the chart doesn't know the context.
See if this link helps... Using dynamic ranges -- DataWright Information Services

Denis

 

[KungPaoDog]

When you click on the Series formula, the bit with the hard-wired range needs to be replaced with something like:
'Worksheet name!NamedRange'

If you just put in the named range, the chart doesn't know the context.
See if this link helps... Using dynamic ranges -- DataWright Information Services

Denis

Yes, I am putting the name in as something like 'Sheet1'!Xvalues.

When I look online I keep finding stuff about dynamic ranges, which is close but not quite what I need. I think that link from DataWright might be closer. Thanks, I'll let you know what I figure out.