CR11 - Controlling bar chart colors

[shera4111]

Hi all, I'm having troubles setting the colours of the bars in my barchart.

Barchart goes:
On Change of ({@modification age}, {assigned_to_group})
Show Value({Count of @modification age})

The on change of for @modification age has a specified order, which is:
30 days or less
31-60 days
61-90 days
91-120 days
120 days or more

I set it up so that the color highlight conditions are the same as the specified order conditions. I also have it set up to 'Color by Groups'.

The idea is that I want the chart to display:
30 days or less -> green
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> red

I can't seem to figure out how to make it happen... the closest I got was when it did this:
30 days or less -> blue
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> orange

I'm likely doing something dumb, but it's driving me mad since there seems to be very little logic here...

shera4111

 

[shera4111]

Ok... I've got it halfway.

I managed to get the colours to come up correctly, BUT ONLY if I mess with the specified order. For some reason, when I specify the order of {@modification date} so that it goes:

30 days or less
61-90 days
91-120 days
31-60 days
120 days or more

Obviously, I want these things in the intuitive order... not all mixed up like this. But as soon as I move 31-60 days back to its correct spot, it turns the wrong colour.

shera4111