VBA question: how to highlight one bar color in pivot chart depending on cell value from drop down list

[sbadrieva]

Hello everyone! I want to highlight a bar red in a pivot chart based on what value is chosen from a drop down list. The values in the drop down list correspond to the x values in the chart. For example, if I choose Blake, Judith in the drop down list I want her bar in the chart to be red and all others blue. I want this to be done automatically so any time a person is chosen fro the list, their bar is highlighted so the viewer can easily find them in the chart.

 

[sbadrieva]

I looked everywhere and cant find a solution, any help or links will be greatly appreciated!!!