Format Selected Chart
 

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

Format Selected Chart
 

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

Format Selected Chart
 

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

Format Selected Chart
 

ActiveChart

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


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