Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR11 - Controlling bar chart colors

Status
Not open for further replies.

shera4111

Programmer
Apr 12, 2006
27
CA
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top