conditional formatting color based upon another field value
I have a Symbol + Grouped Bar chart that I would like to use conditional colors.
X Axis is Customer
Y Axis is (Max)Goal
Series is (Avg) PercentOnTime
I would like to do the following:
If (Series) PercentOnTime >= (Y Axis) Goal = (Series) Green
If (Series) PercentOnTime < (Y Axis) Goal = (Series) Red
Any help would be greatly appreciated.