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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA question: how to highlight one bar color in pivot chart depending on cell value from drop down list
- Thread starter sbadrieva
- Start date
-
- Tags
- excelvba pivotchart vba
Similar threads
- Solved
