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?
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?