automate charting

[joemark]

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]

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"