VBA code for chart

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do charts disappear? 2
Paste Excel Chart into Existing Powerpoint Chart 1
VBA code for Chart 1
I need to give index number to charts 3
Excel Charts and VBA 5
How to identify Chart Source data as range? 3
Create Flow Chart using Excel VBA 2
Set Chart Legend in VBA 1

Back
Top