I have a bar chart that is populated by data in vba code after some calculations have been made. Is there a way to change the colour of the bars that are greater than a maximum y-value? For example if there are 10 bars plotted in the chart and the last 2 bars are over the value of 10, I want to change their colour from green to red. And every time I run the calculations code it will make this check and change the colour if needed.
Bookmarks