+ Reply to Thread
Results 1 to 2 of 2

Format numbers on the x-axis of Chart

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    Format numbers on the x-axis of Chart

    I have a group of numbers on x-axis as follows.


    300,000
    250,000
    200,000
    150,000
    100,000
    50,000

    I want to format to display
    300k
    250k
    200k
    150k
    100k
    50k

    Is there a way to format in this way. I'm pretty sure I need to access the 'Format Cells' option

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: Format numbers on the x-axis of Chart

    Go into axis options - you will find ther units of displaying dropdown list (roughly - I have national version of excel) and select "thousands"

    the other option - use non-standard format for the cells and make sure in axis formatting in Numbers tab you have "connected with source" checked.

    See both in attachment
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. changing x-axis format on chart
    By SAsplin in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-07-2011, 11:39 AM
  2. changing x-axis format on chart
    By SAsplin in forum Excel General
    Replies: 1
    Last Post: 06-07-2011, 05:58 AM
  3. Auto format chart axis
    By freud1 in forum Excel General
    Replies: 3
    Last Post: 10-29-2010, 01:41 PM
  4. Format y axis values for chart
    By nacky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-12-2008, 10:38 AM
  5. X Axis:Change Numbers on Chart ? Please Help!
    By CWriter81 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-29-2005, 10:10 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