background color

[Anonymous]

Hi friends,

Anybody knows how to set background color in chart by place.

I have an expression

rank(sum(AAA))

I'd like set up the first place one color, the second another and so on.

Please help me with idea

Thanks,

[Nicole-Smith · Accepted solution]

pick(rank(sum(AAA)), red() /*first color*/, yellow() /*second color*/, ....)

[giakoum]

if(rank(sum(AAA)=1, RGB(255,255,0), RGB(255,123,255)) for example in the background color expression