color in a graph.

[#1]

Hi experts,

I would like display a graph with a color depending of the dimension value.

StateA always black,

StateB always green...

I did that in the color expressino : =if(Dimension ='StateA', Black(255),if(Dimension ='StateB', Green(255),...))

It's working when I pickup just 1 value but not for a multi selection.

Someone know why?

Thanks.

[#2 · Accepted solution]

I did... the issue not come the fomula but the place where I wrote it.

It's not in colors sheet but in expressions Sheet ->Background color.

[#3]

Hi,

thx for ansering your own question. Had the same question today.

Regards,

Yves