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