How to create conditional background color?

tracycrown · ‎2015-08-22

Dear all

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

Thank You

Tracy

Anonymous · ‎2015-08-22

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 · ‎2015-08-23

Hi please find the below one

alibd225 · ‎2015-08-23

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