+ Reply to Thread
Results 1 to 5 of 5

remove 0 from chart without losing decimal places

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    remove 0 from chart without losing decimal places

    Removing the 0 from my charts is easy, either by adding a custom format to the cell using "0;-0;;@", or editing my data label number -> Custom -> Format Code = #""
    Both these methods though remove my decimal places though, so a 12.5 will become 13 for example.

    Is there a way to stop a 0 from displaying in my chart without also losing my decimal place?

    Thank you for the help.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: remove 0 from chart without losing decimal places

    Try this format:

    [=0]"";General
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Re: remove 0 from chart without losing decimal places

    that's two you've nailed for me now Tony, nice work thank you.

  4. #4
    Registered User
    Join Date
    08-19-2014
    Location
    Dallas, TX
    MS-Off Ver
    Office2013
    Posts
    44

    Re: remove 0 from chart without losing decimal places

    Your format code needs to be a little more specific:

    Number-------------Format Code--------------------- Result

    12.5 ------------------- # ------------------- 13
    12.5 ------------------- #.# ------------------- 12.5
    Last edited by XLPadawan; 06-20-2016 at 07:53 PM. Reason: To fix Alignment issues

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: remove 0 from chart without losing decimal places

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adusting decimal places based on greatest number of places in a series
    By anelson87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2022, 01:05 PM
  2. Replies: 11
    Last Post: 07-25-2015, 02:06 PM
  3. Losing decimal places in .csv file saved in Excel
    By watty in forum Excel General
    Replies: 4
    Last Post: 02-03-2015, 01:44 PM
  4. Set Chart FormatAxis Decimal Places according to value in a cell
    By mrprofit in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2014, 03:56 PM
  5. [SOLVED] Calculating decimal places in a non decimal format (ie sixes not tens)
    By Mike Brewer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 08:58 AM
  6. Paste two decimal number in excel without extra decimal places appearing
    By jeffery_frick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 07:49 PM
  7. [SOLVED] FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.
    By SUKYKITTY in forum Excel General
    Replies: 3
    Last Post: 07-06-2005, 09:05 AM

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