How to Format Percent Entries in a Pie Chart in Excel

 Last reviewed: November 2, 1994
Article ID: Q51589
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

If you have a pie chart in Microsoft Excel with values displayed in percentage format, you can change the number format.

MORE INFORMATION

Microsoft Excel versions 2.x and 3.0

These values represent percentages of values based on a 100-percent scale. The values are in text format. To change any of the values, select the desired value (you will see small squares around the value). Enter the formula bar by pressing F2 and type the new format. For example, if you have an entry such as 25.08% and want to display the integer portion only, enter: 

   ="25%"
This does not change the way the data has been charted.

Microsoft Excel version 5.0

By default, Microsoft Excel version 5.0 formats the percenatges as whole numbers. To change the default formatting, follow these steps:

  1. First select the data labels (make sure that all data labels are selected).

  2. Choose Selected Data Labels from the Format menu.

  3. In the Format Data Labels dialog, choose the Number tab. Under Category, choose Percentage, then select the appropriate percentage format. A custom number format may also be applied to the data labels.

Microsoft Excel version 4.0

Microsoft Excel version 4.0 displays percentages as whole numbers by default.

KBCategory: kbusage
KBSubcategory:

Additional words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00
4.0 4.00 4.0a 4.00a 5.0 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.