+ Reply to Thread
Results 1 to 3 of 3

"Hiding" Specific Horizontal Axis Labels in Bar Graph

  1. #1
    Registered User
    Join Date
    07-18-2014
    Location
    Austin, TX USA
    MS-Off Ver
    2007/2010
    Posts
    15

    "Hiding" Specific Horizontal Axis Labels in Bar Graph

    I have a bar graph for a performance indicator for all personnel. I would like to hide or mask all names on the x axis except for 1 target employee at a time so that i can create an individual report but still show the employee where they stand in the population. I'm guessing I would need to use VBA, but thought there may be a way to do this with conditional formatting. I can create a drop-down to choose the specific employee in a named range, but I'm not sure how to apply that criteria to my chart. If anyone has any ideas on how to do this, I would greatly appreciate it.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: "Hiding" Specific Horizontal Axis Labels in Bar Graph

    Hello
    You could do this in many ways, Dynamic Named Ranges, Helper Tables, Pivot Tables, VBA etc. Perhaps if you could upload a sample file without any sensitive data, outlining what you would like to see in your report, then perhaps other forum members or myself might be able to provide you with some ideas.

    DBY

  3. #3
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: "Hiding" Specific Horizontal Axis Labels in Bar Graph

    Do you have one bar for each employee, and you want to highlight one employee in particular? I've set up an example as follows.

    The data (names and scores) is in A1:B7. The combo uses A2:A7 as the list fill range, and cell E2 is the linked cell. Cell C1 has this formula:
    =INDEX(A2:A7,E2)

    Cell C2 has this formula, which is copied down the column:
    =IF(A2=$C$1,B2,"")

    Cell A1 is blank, which helps Excel make the chart properly.

    The chart is made from A1:C7 (top left chart). The X axis is selected and deleted (top right). The overlap property of either series is set to 100%, so the one highlighted bar appears in front of the other data (bottom left). In addition, the gap width is set to 50%, and the scores data is given a gray fill so the highlighted bar stands out. Finally, you can select the legend entry for the scores series (two single clicks, one to select the legend, the next to select just the one entry) and click delete, so only the highlighted label is shown (bottom right).

    HighlightOneBar.png
    Jon Peltier
    http://PeltierTech.com/

+ 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. [SOLVED] Stacked Area Graphs - How to get a Horizontal "Value" Axis
    By Terrafish in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-15-2013, 05:22 PM
  2. Replies: 2
    Last Post: 07-14-2013, 04:13 PM
  3. Replies: 2
    Last Post: 12-16-2011, 09:40 AM
  4. X-axis labels -- text "jan" "feb", comes out "1" "2" etc....
    By jeremy via OfficeKB.com in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-10-2005, 08: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