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" wrote:

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