+ Reply to Thread
Results 1 to 4 of 4

Trying to access format for individual Axis labels on a chart

  1. #1
    Registered User
    Join Date
    05-11-2018
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    5

    Trying to access format for individual Axis labels on a chart

    Im trying to individually format a label based on other input but I can't locate the right object. Any help or direction is appreciated. Thanks. I've included a super illustrative picture of what I'd like to control


    I guess I can't post the image since I'm new but it is:

    https: // imgur.com / a /mlkUmjG

    Thank you in advance!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Trying to access format for individual Axis labels on a chart

    You can not format individual items within the axis labelling.

    You can fake the axis in order to give you more control.
    http://andypope.info/charts/hiliteaxislabels.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-11-2018
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    5

    Re: Trying to access format for individual Axis labels on a chart

    Thank you Andy, alas I'm not sure this will work for me, I build the charts programatically and I'm not sure having a block of code to define every possible outcome to set up a new series is practical. Thank you again for your help.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Trying to access format for individual Axis labels on a chart

    The example used a formula based approach. You can do it with code if required. Just add 1 extra series and then format each data label as required based on whatever logic you are using.

+ 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 chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  2. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  3. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  4. Format individual axis category labels on chart
    By emm8080 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2012, 12:20 PM
  5. Replies: 1
    Last Post: 06-26-2012, 10:02 AM
  6. Changing individual axis labels on the same axis (vba?)
    By sikey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2010, 06:08 AM
  7. Set Chart Axis labels from Access Query?
    By Mike B in VT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2006, 02:15 PM

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