How can I set diameter of pie charts?

[Rose A]

I am publishing a report that contains a series of pie charts. The number of
slices in the pies and the length of the labels vary in each chart. Excel is
automatically changing the diameter of the pie chart. I need to be able to
set the diameter of the pie so that all pies are the same size.

[A Pragmatic Cynic]

I use John Walkenbach Chart Tools

http://www.j-walk.com/ss/excel/files/charttools.htm



"Rose A" wrote:

> I am publishing a report that contains a series of pie charts. The number of
> slices in the pies and the length of the labels vary in each chart. Excel is
> automatically changing the diameter of the pie chart. I need to be able to
> set the diameter of the pie so that all pies are the same size.

[Rose A]

Thanks!! I'll give it a try. Appreicate your help.

"A Pragmatic Cynic" wrote:

> I use John Walkenbach Chart Tools
>
> http://www.j-walk.com/ss/excel/files/charttools.htm
>
>
>
> "Rose A" wrote:
>
> > I am publishing a report that contains a series of pie charts. The number of
> > slices in the pies and the length of the labels vary in each chart. Excel is
> > automatically changing the diameter of the pie chart. I need to be able to
> > set the diameter of the pie so that all pies are the same size.