I am creating two stacked bar charts (please see attached). I have given the below variables for colours under Expressions > Background Colour.
=if([Rating]>12, RGB(255, 0, 0),
if([Rating] >=8 and [Rating] <=12, RGB(255, 153, 0), RGB(255, 255, 0))
The colours are all over the place. It is working in some bars and not working in others, which is strange. For example, if you select "CFN" under Response list box, it works fine (1 yellow, 1 amber, 1 red). However, if you select "Doc", in spite of giving the right values on the bars, there is a same colour. There seems to be something very simple that is wrong. Please help.