Bar Chart Color Corresponding to Dimension Value

[richardpayne]

I am attempting to create a bar chart where the color of the bar is permanently attributed to the value of a dimension.

I have orders with a given status: late, early, or on time. For each month, there are three bars for each of these values.

I want the "early" bar to be yellow, "late" to be red, and "on time" to be green. I have tried checking the "persistent colors", but this doesn't work. Eventually, as the data changes, the colors swap. Any ideas?

[Oleg_Troyansky · Accepted solution]

Use "Background Color" attribute of the expression and determine your color based on the Dimension Value:

If (Dim1 = 'Late', red()) etc...

cheers,

[richardpayne]

Oh, wow. The background color worked. I was concentrating on the color tab.

Thanks!

[#4]

and how do I do the same for the value on the bar. I want negatives to be red, positives to be blue.

[#5]

Nevermind, just found out.

[#6]

Hello,

In additional, is it possible to attribute an image (like flag) corresponding to dimension value?

See joined file for example.

Thanks for your help

Laurent