+ Reply to Thread
Results 1 to 3 of 3

showing percentages in pie charts

Hybrid View

  1. #1
    Dan
    Guest

    showing percentages in pie charts

    I've created some pie charts, and they work fine, but I need to change the
    percentages to display more granularly by increasing decimal positions.
    There are a number of items showing as 0% when in fact they might be .25% or
    ..33%, and for this particular application I need to be able to show that,
    and so far can't find the answer.

    Thanks,

    Dan

    --


    -------------------------------------------------------------------------
    FIGHT BACK AGAINST SPAM!
    Download Spam Inspector, the Award Winning Anti-Spam Filter
    http://mail.giantcompany.com




  2. #2
    Andy Pope
    Guest

    Re: showing percentages in pie charts

    Hi Dan,

    Double click the data labels and on the Number tab increase the decimal
    places.

    Cheers
    Andy

    Dan wrote:
    > I've created some pie charts, and they work fine, but I need to change the
    > percentages to display more granularly by increasing decimal positions.
    > There are a number of items showing as 0% when in fact they might be .25% or
    > .33%, and for this particular application I need to be able to show that,
    > and so far can't find the answer.
    >
    > Thanks,
    >
    > Dan
    >


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    Dan
    Guest

    Re: showing percentages in pie charts

    Terrific. Worked like a charm. Thanks Andy.

    --


    -------------------------------------------------------------------------
    FIGHT BACK AGAINST SPAM!
    Download Spam Inspector, the Award Winning Anti-Spam Filter
    http://mail.giantcompany.com


    "Andy Pope" <andy@andypope.info> wrote in message
    news:eHd9v2SBFHA.2012@TK2MSFTNGP15.phx.gbl...
    > Hi Dan,
    >
    > Double click the data labels and on the Number tab increase the decimal
    > places.
    >
    > Cheers
    > Andy
    >
    > Dan wrote:
    >> I've created some pie charts, and they work fine, but I need to change
    >> the percentages to display more granularly by increasing decimal
    >> positions. There are a number of items showing as 0% when in fact they
    >> might be .25% or .33%, and for this particular application I need to be
    >> able to show that, and so far can't find the answer.
    >>
    >> Thanks,
    >>
    >> Dan
    >>

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info




+ 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