Change text colour based on value

peterderrington — Tue, 03 Mar 2020 10:48:07 GMT

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.

Re: Change text colour based on value

girish21595 — Tue, 03 Mar 2020 11:14:43 GMT

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

Regards,

Girish.

peterderrington — Tue, 03 Mar 2020 14:17:55 GMT

Fantastic,

Thank you!