Format Selected Chart

[John]

I am trying to write a VBA code that will take the selected Pie chart and
modify the size of the chart and the plot area. This is my first venture into
VBA and I'm not having much luck. Was wondering if someone could point me in
the right direction.

Using Excel 2003

 

[Jon Peltier]

Record a macro while you perform the actions you need, then punch up the
macro.

See also:
http://peltiertech.com/Excel/Charts/chartvba.html
http://peltiertech.com/WordPress/2008/03/10/how-to-recording-your-own-macro/
http://peltiertech.com/WordPress/2008/03/11/how-to-fix-a-recorded-macro/

- Jon

 

[John]

Thanks! Lots of good info here.

Question, how to you reference the selected chart? In most examples dealing
with this subject you need to reference the charts name. When I first tried
to create a macro that resized the chart, it keeps trying to resize the same
chart. I want it to resize the chart I have selected when I run the macro.

Any ideas?

 

[Jon Peltier]

ActiveChart

- Jon