Pie Chart size

[Jorist]

I have four Pie Charts that I need to use for some reports in a worksheet.
The worksheet is setup to print all four pie charts on one page. My problem
is that when I add and change data to the sources for the pie charts, the
pie charts keep changing size. I need to have all of the PIES in each pie
chart to be the same size regardless of the data and labels. Is there anyway
that I can specify the size of the pies such that they are all the same and
do not change?

Thanks for any help
J

 

[Debra Dalgleish]

Jon Peltier posted some code in the following message that should help
you fix the pie charts:

http://groups.google.com/groups?&[email protected]

 

[Jorist]

Thanks Debra! Do you know how I can achieve the same results with a 3D Pie
Chart?

J

 

[Debra Dalgleish]

In the code, replace xlPie with xl3DPie. (You can use Edit>Replace to
find the two instances)

 

[Jon Peltier]

Speaking as a purist, I'd make the following correction:

"in the chart, replace xl3DPie with xlPie."

Adding a false third dimension to a chart always distorts the data, by
forcing an unnatural perspective on the chart, by misleading the viewer
into thinking that the third dimension means something, and by
nonuniformly changing the sizes of different plotted values in the chart.

What? you say, advertisers use 3D charts like this all the time.

Case in point.

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