OFFSET/COUNTA Function and Charts

Morning,

Currently working on a stock project and tracking the stocks in excel. I have about 40 sheets in the workbook all with connections to Yahoo Finance to update everyday with the new closing price. Anyways, I want to set up charts so that everyday when it updates it will automatically enter with minimal work.

Here's what I have for my chart

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

I have those defined, btw

The Problem. When it updates, it does from the top. So the new data is at the top, and not the bottom. The formula works if I insert the data at the bottom, but not for when the new data is in A2 and E2, because when the connection updates for a new day it the new data is ascending down.


I really hope this makes sense to someone and I thank you for your time and apologize for any confusion.


Thanks,

DG

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

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

Originally Posted by Dgreiner

I was so close, but yet so far.

Been there