+ Reply to Thread
Results 1 to 2 of 2

Custom number on Chart Axis - Shortening negative and postive numbers

  1. #1
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Lightbulb Custom number on Chart Axis - Shortening negative and postive numbers

    Hello,

    I am trying to create a custom number format, and I can only get it to work for positive or negative numbers, not both. I am trying to abbreviate/shorten thousands to K and millions to M.

    Please Login or Register  to view this content.
    That works for positive numbers, but on my graph I have negative as well. I am using Excel 2003 and I'm not sure if I can add any more conditions?


    Thanks in advance..

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Custom number on Chart Axis - Shortening negative and postive numbers

    Hi,
    I'm not sure if I can add any more conditions?
    I don't think you can. According to the Excel help you can have up to two conditions in a custom number format, not more.

+ 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