How to create conditional background color?

[tracycrown]

Dear all

Kindly advise how to create a conditional background colour for Category B & C ?.

Thank You

Tracy

[fkeuroglian]

Tracy, see the attaced

You have to put the condition in the "Background color" to each expression(in this case Category)

hope helps

Fernando

[Anonymous]

Hi Tracy,

Goto Expression

expand + sign for expression

and add below expression in background colour.

if(Category='A',yellow(),

if(Category='B',green(),

if(Category='C',red(),blue())))

or

if(Category='A', RGB(255,255,0),

if(Category='B',RGB(255,123,255),

if(Category='C',RGB(255,120,80),RGB(153,207,255))))

[prabhas277]

Hi please find the  below one

[alibd225]

go chart properties . expand and set formula under background coolor

if(Category='A', RGB(255,255,0),

if(Category='B',RGB(255,123,255),

if(Category='C',RGB(255,120,80),RGB(153,207,255))))