Format Selected Chart

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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?
 
Back
Top