+ Reply to Thread
Results 1 to 2 of 2

percentages in an excel pie chart

  1. #1
    Alexis
    Guest

    percentages in an excel pie chart

    How do I manually enter percentages into an excel pie chart. I already have
    the percentage values from a history project and now I need to enter them
    into a pie chart for a visual.

  2. #2
    Greg Wilson
    Guest

    RE: percentages in an excel pie chart

    You don't need to enter percentages. Just plot the data. Excel calculates the
    percentages for each element relative to the sum of all data. Example:

    A1 = 1 Pie chart returns: 2%
    A2 = 5 Pie chart returns: 12%
    A3 = 5 Pie chart returns: 12%
    A4 = 5 Pie chart returns: 12%
    A5 = 25 Pie chart returns: 62%

    Note that Excel rounds the percentage values.

    Regards,
    Greg

    "Alexis" wrote:

    > How do I manually enter percentages into an excel pie chart. I already have
    > the percentage values from a history project and now I need to enter them
    > into a pie chart for a visual.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1