• Rounding, Excel 2000 Chart

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Rounding, Excel 2000 Chart

    Author
    Topic
    WSPitseleh
    AskWoody Lounger
    April 6, 2001 at 3:25 pm #354759

    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.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSAndrew Cronnolly
      AskWoody Lounger
      April 6, 2001 at 6:23 pm #521893

      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

      Reply | Quote
      • WSPitseleh
        AskWoody Lounger
        April 6, 2001 at 6:29 pm #521895

        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?

        Reply | Quote
        • WSShane Sargent
          AskWoody Lounger
          April 6, 2001 at 6:40 pm #521899

          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! shrug Best of luck!

          Reply | Quote
        • WSAndrew Cronnolly
          AskWoody Lounger
          April 6, 2001 at 6:46 pm #521902

          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

          Reply | Quote
    Viewing 0 reply threads
    Reply To: Rounding, Excel 2000 Chart

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.