Calculated range reference in graph

C

Compcat

=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?
 
C

Compcat

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!
 
Top