named range refers to: in a chart
 

i have a simple line chart. i have a named range "Current"
the range refers to:
OFFSET(INDIRECT(CELL("address",OFFSET(A1,MATCH(LAR GE(A:A,1),A:A,0),2,1,1))),
0,0,1,COUNTA(INDIRECT((ROW(OFFSET(A1,MATCH(LARGE(A :A,1),A:A,0),2,1,1)))&":"&
(ROW(OFFSET(A1,MATCH(LARGE(A:A,1),A:A,0),2,1,1)))) )-1)

however, when i try to use this named range as the data range for my chart,
it gives me an error "Reference not valid" the formula above returns a
range of 1 row by about 25 columns. so its only 2 dimensional. why can't
the chart use this named range? TIA.

Is there a reason your named range is so complicated?

http://www.contextures.com/xlNames01.html#Dynamic


Regards,

Peo Sjoblom

"Spencer Hutton" wrote:

i have a simple line chart. i have a named range "Current"
the range refers to:
OFFSET(INDIRECT(CELL("address",OFFSET(A1,MATCH(LAR GE(A:A,1),A:A,0),2,1,1))),
0,0,1,COUNTA(INDIRECT((ROW(OFFSET(A1,MATCH(LARGE(A :A,1),A:A,0),2,1,1)))&":"&
(ROW(OFFSET(A1,MATCH(LARGE(A:A,1),A:A,0),2,1,1)))) )-1)

however, when i try to use this named range as the data range for my chart,
it gives me an error "Reference not valid" the formula above returns a
range of 1 row by about 25 columns. so its only 2 dimensional. why can't
the chart use this named range? TIA.