change diameter of a pie chart in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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