updating chart problem

[kole]

I am using one workbook with prices to update another workbook with charts. I am using this link.
='[YahooMultipleHistory97a_P ALL SCOTTRADE.xls]Symbols'!$BJ$4:$BJ$225
How can I get the BJ$225 to be BJ$226 the next day and BJ$227 the next day and on and on?

 

[Jon Peltier]

Check out the dynamic chart examples and links here:

http://peltiertech.com/Excel/Charts/Dynamics.html