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

Answers

This discussion has been closed.