Funny thing with that 33%-33%-34% pie chart, if you increase the decimals in
the number format, it becomes 33.3%-33.3%-33.3%. Maybe Excel assumes that
someone who understands decimals and percentages together is savvy enough to
cope with the totals not appearing to sum to 100%.

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


"Jon Peltier" wrote in message
...
This adjustment came relatively recently to Excel, IIRC. In Excel 97 and I
think 2000, the percentages were not tweaked, so three equal pie slices
would each say 33%. In either 2002 or 2003, Excel started rounding one of
the wedges the wrong way, to 34%, so that the sum was 100%. Maybe this was
to satisfy those brilliant CEOs and CFOs who could add percentages in a
pie chart and fretted that there was a 1% rounding discrepancy, but went
down in flames when the internet bubble burst.

Of course, if you want the pie chart to show 35%, 25%, and 0%, you could
select the Value option, not the Percentage option. If you want it to
accurately show 35% and 25% of a whole, you should add another wedge of
40%, and format it with no lines and no fill. If you're wondering where
61% and 39% came from, you should calculate the percentages yourself:
35%/(35%+25%) and 25%/(35%+25%), although I got 58% and 42%, as did my pie
chart.

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


"tshad" wrote in message
...
We just ran into a real problem where the Charting on Excel will
recalculate your numbers.

Excel wants to make it 100%

The problem is that our numbers are not 100%.

For example:

I have a table:
A B C
35% 25% 0%

What we got was a Pie Chart that showed:

A B C
61% 39% 0%

I have another one that is11,26,11,1,2 which equates to (in percentage)
21.57,50.98,21.57,1.96,3.92. Now this equates to 100%. but the table I
am using only has whole numbers: 22,51,22,2,4 which equates to 101%
(which is incorrect). This is a rounding anomaly in that all the numbers
rounded up - not much you can do about that. But the problem chooses
which number to change to make it 100% (in this case it changed the 51 to
a 50).

Is there a way to tell the Pie Chart not to adjust the numbers even if
they don't equal 100%?

The problem here is that if you look at the table and the chart, they are
different and it looks incorrect because it doesn't match.

Thanks,

Tom