Bar Chart colour consistency

[#1]

Hi there

How do I assign a specific colour to a specific dimension on my chart ?  For some reason they keep on changing.  Dont know if it has something to do with the sort order, but the colours keep on swapping out.

Awaiting Information dimension should ALWAYS be white.  Danger dimension should always be amber, etc......

[ashwanin]

Might be you have implemented the Section access in this document. Please remove that.

Else try with the If condition, that will work for you.

[#3]

Section Access removed now.....

[awhitfield]

.

Here you go,

Set sla sort order a-z, switch off persistent colours and set your 1-6 colours the same for each chart

Andy