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.