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