Microsoft KB Archive/29745

Some Pie Charts Do Not Add Up to 100 Percent

PSS ID Number: Q29745 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

Problem: My percentages add up to 100.1 percent when I do the following:


 * 1) Enter numbers such as 6, 10, 3, and 12.
 * 2) Execute a Chart New and Format for Pie.
 * 3) View the Chart.

Response: This is inherent whenever numbers are rounded and then summed. If you have the numbers 7.3, 7.4, and 7.3, the sum is 22. If you round them to integers and sum them, the result is 21. The percentages you are adding are not exact percentages, but percentages rounded to one digit after the decimal point. The sum of these rounded percentages may be different (99.9 or 100.1 in the cases described) than the sum of the exact percentage, which would be 100.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.