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

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

Thank you. But it will be quite complicated to recreate the chart to
record the macro.

Is there any other way? For example, is there any way to uncover the
VBA code which corresponds to the generated chart?

No - not directly.

the alternative is to learn the object model for Charts and program it.

or
make a copy of your chart, then turn on the macro recorder and make minor
changes to major elements of the copy of the chart. The macro recorder
often captures a lot of the settings associated with that change.

--
Regards,
Tom Ogilvy


"chris" wrote in message
oups.com...

Thank you. But it will be quite complicated to recreate the chart to
record the macro.

Is there any other way? For example, is there any way to uncover the
VBA code which corresponds to the generated chart?