I have a bar chart to display information.
I also have a vertical line indicate the limit of Y-value.
For example, I set the limit to 25.
So now I want the color of column bar to change to red color if the column exceed the limit.
I tried this but the result, i get all column color changed, not only column that exceed the limit.
Dim maxAlert = GetMax() \\ get maximum column value. If maxAlert > 25 Then .Color = Color.Crimson \\if max value exceed 25, the color changed Else .Color = Color.LightCoral End If
This is the example of outcome that I want:
How can I changed the column color to red when it exceed the limit? Thank you :)