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/200...our-own-macro/
http://peltiertech.com/WordPress/200...ecorded-macro/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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