Automatic Charting

dshiver · Apr 24th, 2002, 11:00 AM

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 · Apr 24th, 2002, 11:26 AM

rty this select the range data and hit F11

dshiver · Apr 24th, 2002, 11:30 AM

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 · Apr 24th, 2002, 11:31 AM

Hi dshiver.

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

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

Apr 24th, 2002, 11:26 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	rty this select the range data and hit F11 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 24th, 2002, 11:31 AM	#4
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi dshiver. There is a great description about how to do this using a dynamic range at: http://www.beyondtechnology.com/geeks021.shtml __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 11:00 AM	#1
dshiver New Member Join Date: Apr 2002 Posts: 4	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.

Apr 24th, 2002, 11:30 AM	#3
dshiver New Member Join Date: Apr 2002 Posts: 4	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