+ Reply to Thread
Results 1 to 5 of 5

Changing X axis ticks label

  1. 10-27-2019, 04:05 AM #1
    rainbringer
    rainbringer is offline
    Registered User
    Join Date
    10-27-2019
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    6

    Changing X axis ticks label

    Hello,
    I've a simple task progress table: status (NA, start, ongoing, completed) vs. person's name.
    I try to plot it on a bar chart, so that each status will appear in a different color (red, orange, light green, dark green) and the X labels would be the status words but I can't understand how it is done.

    The conditional formatting of the bars I achieve with the technique from Peltier Tech Blog "Conditional Formatting of Excel Charts", but I can't manage to substitute the numbers in X axis by the verbal statuses.

    The example sheet is attached.

    I'll appreciate your help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-27-2019, 06:57 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,786

    Re: Changing X axis ticks label

    Welcome to the forum.

    Can you show us what you want to achieve? Manually mock this up in your workbook.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-27-2019, 07:16 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Changing X axis ticks label

    You can use a dummy series, plotted as xy-scatter, to plot points along the horizontal axis.
    The use data labels, linked to cells, to display the descriptions of values , 0, 1, 2 and 3.
    Remove the actual horizontal axis labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  4. 10-27-2019, 08:29 AM #4
    rainbringer
    rainbringer is offline
    Registered User
    Join Date
    10-27-2019
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    6

    Re: Changing X axis ticks label

    Andy, thank you for your reply. That's exactly what I've been looking for!

    I'll add that how to combine different chart types in one plot is described in Peltier Tech Blog, "For Bar-Line (XY) Combination Chart in Excel" thread.

    P.S. Ali, thanks for the welcome words
    Last edited by rainbringer; 10-27-2019 at 08:35 AM.
    Reply With QuoteRegister To Reply
  5. 10-27-2019, 08:58 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,786

    Re: Changing X axis ticks label

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to increase the amount of ticks on x-axis?
    By krabine in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-01-2016, 11:53 AM
  2. Making axis ticks appear on RHS of vertical axis
    By sillius_soddus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-05-2014, 11:56 AM
  3. I want more number of intervals in terms of minor ticks on x axis.
    By vishwajeet in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-15-2014, 03:54 AM
  4. Changing X axis label range automatically and Create line for today
    By aaslezak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2013, 01:01 PM
  5. Changing the label on the Horizontal Axis
    By vkartikv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-25-2013, 05:04 AM
  6. Can I shift (or offset) interval ticks on chart axis?
    By JayUSA in forum Excel General
    Replies: 2
    Last Post: 04-27-2009, 04:10 AM
  7. Gridlines and axis ticks misplaced
    By blane245 in forum Excel General
    Replies: 6
    Last Post: 02-25-2009, 10:58 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1