Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 04, 09:40 PM
Spencer Hutton
 
Posts: n/a
Default 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.



  #2   Report Post  
Old December 14th 04, 10:15 PM
Peo Sjoblom
 
Posts: n/a
Default

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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
3 cells are named - how to refere to them in one reference field in a chart Marie J-son Charts and Charting in Excel 2 December 2nd 04 04:52 PM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017