Automatic Charting

[dshiver]

I use a excel worksheet with stock data. in column A I have the dates jan 1 2002 - dec 2002. column B down I have the stock close price. Each day I add the close price in column B, how can I make the chart range grow automatically, so that tomorrow it is charting the close price that i put in each day and so on.

 

[Jack in the UK]

rty this select the range data and hit F11

 

[dshiver]

But what if I already have a chart and just wanted the price i put in each day to be added autoamtically to an existing chart, how can i make the range grow automatically

 

[Damon Ostrander]

Hi dshiver.

There is a great description about how to do this using a dynamic range at:

http://www.beyondtechnology.com/geeks021.shtml