change diameter of a pie chart in excel

[Lisa]

I am trying to make the sizes of all pie charts the same. I have made all
the boxes the same size by using format - object and making widths and
heights the same, however when this is done the diameter of each pie chart is
different. Any ideas to correct this. Thanks

 

[Andy Pope]

Hi Lisa,

To change the diameter you need to adjust the Plotarea dimensions.
For consistent setting this is best done with vba code.

The following code snippet will alter the position and width (diameter).

With ActiveChart.PlotArea
.Left = 20
.Top = 20
.Width = 60
End With

Cheers
Andy

 

[Jon Peltier]

Lisa -

I have a whole lot of pie chart information in this article. Near the end I have a
few macros that help with sizing of the charts.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

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