Consulting

Results 1 to 3 of 3

Thread: Solved: making a pie chart show decimals in a percentage

  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Solved: making a pie chart show decimals in a percentage

    Does anyone know how to make a pie chart show decimal places in percentage instead of rounding the number up? Thanks

  2. #2
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    You can select the data labels and press the Increase Decimals toolbutton

    or CTRL+1 to bring up the format dialog and on the Number tab set the decimals places for percent format.
    Cheers
    Andy

  3. #3
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Thanks Andy. I was trying to do it by selecting the slice of the pie and not the number label itself. Thanks for pointing that out.

Posting Permissions

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