Percentage rounding error in charts

I am making a pie chart from a table of numbers where the sections of the pie
represent percentage of total. The numbers are rounding incorrectly on the
pie chart. For example, 74.7% is rounding to 74%, not 75%. How can I correct
this?

I can't reproduce this - does the label indicate 74.7% if you set the
number of decimal places to 1?

In article <64374268-5991-4014-A9FD-3599F11EDEAF@microsoft.com>,
Tracey <Tracey@discussions.microsoft.com> wrote:

> I am making a pie chart from a table of numbers where the sections of the pie
> represent percentage of total. The numbers are rounding incorrectly on the
> pie chart. For example, 74.7% is rounding to 74%, not 75%. How can I correct
> this?

Yes it does indicate 74.7% if set to a decimal of 1. Also when you are in the
dialog box selecting the number of decimal places as 0, under the sample
illustration it will say 75%. However when you exit the dialog and view the
chart, it says 74%.

"JE McGimpsey" wrote:

> I can't reproduce this - does the label indicate 74.7% if you set the
> number of decimal places to 1?
>
> In article <64374268-5991-4014-A9FD-3599F11EDEAF@microsoft.com>,
> Tracey <Tracey@discussions.microsoft.com> wrote:
>
> > I am making a pie chart from a table of numbers where the sections of the pie
> > represent percentage of total. The numbers are rounding incorrectly on the
> > pie chart. For example, 74.7% is rounding to 74%, not 75%. How can I correct
> > this?
>

Excel rounds percentages on a pie chart such that they are integers that
add to 100%. Depending on the areas of the other slices, that may
require at least one percentage to round in a nonstandard way. For
instance if the areas were

74.7%
5.8%
5.8%
13.7%

then normal rounding to integer percents would sum to 101% rather than
100%. Excel must then round one of the numbers down so that the total
is 100%. The best one to round down in this case would be 74.7%,
because that choice would result in the smallest relative error.

Jerry

Tracey wrote:

> I am making a pie chart from a table of numbers where the sections of the pie
> represent percentage of total. The numbers are rounding incorrectly on the
> pie chart. For example, 74.7% is rounding to 74%, not 75%. How can I correct
> this?

<slap forehead>Doh!</slap forehead>

In article <428565CD.3000407@no_e-mail.com>,
"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote:

> Excel rounds percentages on a pie chart such that they are integers that
> add to 100%.