Calculated range reference in graph

[Guest]

=QTData!$E$2:"$E$"&COUNTA(QTData!E:E) gives an error in the graph X Values
field. I want to graph some data that I load from Access. The problem is
that I do not allways want to plot the same number of points. What I hoped
would work is just to concatenate the calculated end to the range statement.
How do I make this work?

 

[Frank Kabel]

Hi
not tested but try:
=INDIRECT("'QTData'!$E$2:$E$"&COUNTA(QTData!E:E))

 

[Guest]

Sorry, that did not work. Invalid function error message.

 

[Frank Kabel]

Hi
have a look at:
http://peltiertech.com/Excel/Charts/Dynamics.html
for dynamic charts

 

[Guest]

Yes! Putting =OFFSET(QTD!$E$2,0,0,COUNTA(QTD!C:C)-1,1) in a name reference
and using that in the chart range worked! Thanks a lot!