Bar Graph Colors Specific to Value?

[#1]

This may be impossible, but I have a graph that shows 2 dimensions (stacked): Total Tickets Submitted and Urgency. I have set the colors to show as follows:

However, when you select a single user that does not have all the Urgency fields present, the colors default to the beginning. If I select the User on the far left of the image above:

Is there a way to specify in the bar graph colors that 'Urgent' always equals Red, 'Very High' always equals Orange, etc.?

[Nicole-Smith]

Instead of setting the colors on the Colors tab, you need to write a Background Color Expression for it for each of your expression(s):

[#3]

Would you be able to provide a test file by chance? I don't think I understand how the expression can change the color.

[Nicole-Smith · Accepted solution]

Here you go.

You can use rgb values for the colors, i.e. red would be rgb(255, 0, 0).

[#5]

That is exactly what I was looking for. Thank you!!!