Cyclic Group - colors

[#1]

I have a cyclic group as a dimension.

This cyclic group is made up of 3 dummy variables (yes/no)

I have a bar chart using this cyclic group.

yes should be displayed as a green bar, no as a red bar.

However, for one of the 3 fields in the cyclic group, this is vice versa (no is green, yes is red).

I can't seem to change this...

any ideas?

[its_anandrjs]

Hi,

Write a code some thing like in the background properties of the chart by click on + sigh and add this code there

If( YourField = Yes,Green( ), if( Yourfield = No, Red( ), Black( ) )

If you have any sample file so share it.

Rgds

Anand

[SunilChauhan]

in express -> click on + sign -> background color->use the formula

if(col1='Yes' or col2='Yes' or Col3='No',Green(),Red())

you can set this formula for yes and no as you required i.e which one you want green and what you want red

[#4]

Thanks for the help.

However, this still didn't work out for me.

I've found a solution though...

Apperently the difference in color was caused by a different sort order... so make sure all fields in your cyclic group are sorted the same way...

Furthermore, on the "sort" tab of your chart, make sure "override group sort order" is not selected.