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.