Colors in formula

[Maciej29]

How to combine below formula with custom colors for each status ? I need it for bars in bar chart. Any thoughts ? Thanks in advance.

yellow - STARTED

brown - PENDING

red - ON HOLD

blue - IN PROGRESS

purple- IN REVIEW

green- PROCESSED

=If(Match([STATUS],'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED'),[STATUS])

[NitinK7 · Accepted solution]

first create a master dimension for status and field box below exp

=pick(match(Status,'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED'),
'STARTED','PENDING','IN REVIEW','ON HOLD','IN PROGRESS','PROCESSED')

and hit create button.

after click this master dimension and edit this

then click value color tab

then set your colors based on status values

and use this master dimension in your chart and color section set color by dimension