Turn on the macro recorder while you create the first one manually.

then adjust the code to do what you want.

--
Regards,
Tom Ogilvy


"chris" wrote in message
oups.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