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
thanks a lot.
This message was edited by joemark on 2002-04-02 23:27