Named Range for chart data using ROW and INDIRECT

[sweep]

Hi All,

I am in the process of creating a sheet that has a dynamic chart by using a named range for the data source.

data=Sheet1!$A$2:INDEX(Sheet1!$A$2:$A$20000,MATCH(9.99999E+307,Sheet1!$A$2:$A$20000,1))

I can use the named range "data" in formulas and as the data source for a chart.

I would like to generate a range of integers to use as axis labels. For this particular application, the labels should be integers, starting at 2. To this end, I created a named range like so;

xAxis_Labels=ROW(INDIRECT("2:"&COUNT(Data)))

I can use the named range"xAxis_Labels" in formulas successfully, but when I try and use it to label a set of data, or as a data source in a chart, I get the error:

A formula in this worksheet contains one or more invalid references......

Any ideas?