Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding, Excel 2000 Chart

    I have percentage data labels in a chart, but I don't want the data labels to be automatically rounded up. Is there a way to control this rounding?

    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rounding, Excel 2000 Chart

    When you have your chart in place, right click on the data labels and then select Format Data Labels, and use the number tab to set your preferences.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding, Excel 2000 Chart

    I did not notice an option to "not round up" in that area. I know you can set the decimal places, but can you specify that the numbers not be rounded up?

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding, Excel 2000 Chart

    The label is going to have to round at some point, but you have control as to the number of places to the right of the decimal that you'd like it to perform that at. So, if you want to see 3 significant places to the right of the decimal, perhaps you want to specify 4 in the formatting so you get 3 unrounded places. Seems a bit kludgy now that I've put it on paper, but it's all I have! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Best of luck!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rounding, Excel 2000 Chart

    I am not sure what you mean by rounding up - presumably yo mean rounding from something like 74.75% to 75%, if that is so then such rounding is due to formatting. You can link the format to match the formatting you use in the data table by selecting the link to source switch. Excel defaults to zero decimal palces for percentage values, but you can modify the % style by using Format|Styles.

    Hope that helps

    Andrew C

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding, Excel 2000 Chart

    Or you can round the raw data the way you want in the sheet first, then graph the rounded data instead of the raw data. Check out the "6. ROUNDING OPTIONS IN EXCEL" section of Woody's Office Watch vol 4 number 36, at this link:

    http://www.woodyswatch.com/office/ar...ate.asp?v4-n36

Posting Permissions

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