Microsoft KB Archive/112773

= Pie Chart Shows Incorrect Percentage Value =

PSS ID Number: 112773

Article Last Modified on 8/15/2003

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows
 * Microsoft Graph 5.0 for Windows
 * Microsoft Graph for Macintosh 5.0

-



This article was previously published under Q112773





SYMPTOMS
In Microsoft Excel or Microsoft Graph, when you display percentages in a pie chart, an incorrect percentage may be displayed for the largest number in the series.



CAUSE
Because of the way Microsoft Excel and Microsoft Graph round numbers, the percentages will often add up to be 101 percent instead of 100 percent. When this happens, Microsoft Excel and Microsoft Graph subtract 1 percent from the largest number in order to force the total percentage to equal 100 percent.



WORKAROUND
To work around this problem, use the appropriate method for your version of Microsoft Excel.

Microsoft Excel 7.0 and Excel 97
To use this method, follow these steps:


 * 1) Select all of the data labels by clicking any of the individual data labels on the chart.
 * 2) On the Format menu, click Selected Data Labels.
 * 3) Click the Number tab. In the Decimal Places box, type "2" and click OK.

Microsoft Excel 5.0
To use this method, follow these steps:


 * 1) Select the largest data label by slowly clicking twice (do not double click rapidly). This ensures that only the largest data label is selected.
 * 2) On the Format menu, click Selected Data Labels.
 * 3) On the Number tab, click the Percentage Category with a 0.00% format. This should cause the second largest data label to correctly round up to become the largest label.
 * 4) Select all data labels and reformat them as needed by clicking Selected Data Labels on the Format menu, and then selecting the appropriate number format on the Number tab.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



MORE INFORMATION
Incorrect percentages can also occur when you use percentages in your data (even when your percentages equal 100.00%). When you use Microsoft Graph version 5.0, the sample data in the range A1:B10 that follows produces an incorrect data label. The value 34.2% is displayed as 33.2% when the data label is set to "Percent" or "Label and Percent." When the data label is set to "Value" the value appears correctly.   A1: Name       B1: Sales A2: Ford      B2: 24.7% A3: GM        B3: 34.2% A4: VW        B4:  0.6% A5: Chrysler  B5: 13.3% A6: Toyota    B6:  8.0% A7: Honda     B7:  6.0% A8: Other     B8:  6.0% A9: Mazda     B9:  2.6% A10: Nissan   B10:  4.6%

Additional query words: 5.00a 5.00c 8.00 97 Graph XL

Keywords: kbbug kbpending kbualink97 KB112773

Technology: kbAccessSearch kbExcel97Search kbExcelSearch kbExcelWinSearch kbGraph500 kbGraph500Mac kbGraphMacSearch kbGraphSearch kbHWMAC kbOSMAC kbPowerptMacSearch kbPowerPtSearch kbWordMacSearch kbWordSearch kbZNotKeyword3

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.