Change text colour based on value

[peterderrington]

Hi, 

I have a straight chart where i want the values to change colour dependant on the value.

There are three possible values; Early, On Time and Late

I'm currently using this expression within the 'Text Color' element of the expression: 

=if(Finish='On Time',Green(),RGB(255,0,0))

Which is only allowing me to have the On Time values to show as green with everything else red.

Ideally i'd like the following value/colour matches:

On Time - Blue

Early - Green

Late - Red

I'm presuming i need some sort of dual If statement but i can't quite seem to fix it.

[girish21595 · Accepted solution]

Pick(Match(Finish,'On Time','Early','Late'),Blue(),Green(),Red())

Regards,

Girish.

[peterderrington]

Fantastic, 

Thank you!