OFFSET/COUNTA Function and Charts

Originally Posted by Bob Phillips

How about


Date=OFFSET($A$1,1,,COUNTA($A$1:$A$47)-1) x axis
Closing Price=OFFSET($E$1,1,,COUNTA($E$1:$E$47)-1) y axis

PERFECT! A million thanks! I was so close, but yet so far.


-DG