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.