automate charting

joemark · Apr 3rd, 2002, 12:26 AM

I have a spreadsheet recording daily stock price. I want to have a chart to reflect the price trend and I don't want to do the charting every time by hand. could anyone tell me how to automate charting with weekly or monthly data? could I use macro to draw the chart? and then weekly or monthly I could run the macro to create the chart? how?
thanks a lot.

[ This Message was edited by: joemark on 2002-04-02 23:27 ]

Dave Hawley · Apr 3rd, 2002, 12:48 AM

Hi Joe

You could create a dynamic named range and then drop your data straight into this range. This way you need not keep recreating charts.

I have some samples of these great named ranges here:
http://www.ozgrid.com/Excel/DynamicRanges.htm

I also have some examples of charts that can alter automatically by Day, Week, Month or Year here: http://www.ozgrid.com/Excel/ChartTips.htm These are near the bottom under:
"Two Handy Dynamic Ranges For Charts"

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

Apr 3rd, 2002, 12:26 AM	#1
joemark New Member Join Date: Apr 2002 Posts: 1	I have a spreadsheet recording daily stock price. I want to have a chart to reflect the price trend and I don't want to do the charting every time by hand. could anyone tell me how to automate charting with weekly or monthly data? could I use macro to draw the chart? and then weekly or monthly I could run the macro to create the chart? how? thanks a lot. [ This Message was edited by: joemark on 2002-04-02 23:27 ]

Apr 3rd, 2002, 12:48 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Joe You could create a dynamic named range and then drop your data straight into this range. This way you need not keep recreating charts. I have some samples of these great named ranges here: http://www.ozgrid.com/Excel/DynamicRanges.htm I also have some examples of charts that can alter automatically by Day, Week, Month or Year here: http://www.ozgrid.com/Excel/ChartTips.htm These are near the bottom under: "Two Handy Dynamic Ranges For Charts"