Bar Chart Question

[#1]

I am trying to create a multicolored bar chart which has 1 dimension and 1 expression, chart below.  The dimension results in 6 different bars which are sales territories and I need them all to have a unique color.  I don't want to have 6 different expressions, is there a way to use the color functions within the dimension?

[Anonymous]

On the Expression click the + to its left and double click Background Color,

Here add simple expression like red() and all the bars will turn red.

Then you can add an if as in:

     if ( [YoruDim='Something' , red() , blue() )

From there you can nest if's until you get what you desire.

[ecolomer]

You can use the option in label colour for MULTICOLOUR and select the colours in the list

[Anonymous]

so are you unable to select multicolored in colors tab?

[#5]

Thank you guys for responding so quick!  I was able to figure it out with a combination of a couple of your comments.  The if statement needs to go in the "Background" format of the Expression.

[#6]

I couldn't get the Milticolor box to become active.  In other Bar Charts I have that capability, the only difference between the two is the one I was originally trying to work off of is a Combo Chart.  Do you think that is the reason I can't choose the Multicolor option?