VBA code for Chart

[homescu@cs.ucsb.edu]

Hello everybody
How do I get the VBA code on the Chart once the chart is generated
(manually)?
I would like to automate this process of obtaining the charts for
several worksheets at once
Thank you

[R.VENKATARAMAN]

i suggest you click <record macro> and then start creating a chart on some
experimental data and finally quit recording macro.
clikc tools, macro macro and highlight the particualr macro-name and click
edit you see the code statemnts
you only need to modify to make it general.

<homescu@cs.ucsb.edu> wrote in message
news:1132149187.465431.106250@g49g2000cwa.googlegroups.com...
> Hello everybody
> How do I get the VBA code on the Chart once the chart is generated
> (manually)?
> I would like to automate this process of obtaining the charts for
> several worksheets at once
> Thank you
>