There are at least two interpretations of your request:
1. You could Insert|Name|Define and define two names, "yValues" with a
formula of B1:B5, and "xValues" with a formula of =OFFSET(xValues,0,-1)
which would allow you to reference values in A1:A5 without typing the
explicit reference. Then when you change the range for yValues, the
range for xValues would ajdust automatically.
2. You could use
=LINEST(B1:B5,ROW(B1:B5))
and then do a search and replace of B1:B5 to B13:B17 to use x values of
1,2,3,4,5 in your first case, and 13,14,15,16,17 in the second case.
Note that you could use
=LINEST(B1:B5)
as a shortcut to have the x values be 1,2,3,...
Jerry
