ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   named range refers to: in a chart (https://www.excelbanter.com/excel-discussion-misc-queries/1882-named-range-refers-chart.html)

Spencer Hutton

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.



Peo Sjoblom

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.





All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com