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.

Best Answer


This discussion has been closed.