Mix of colour in Block Chart

[iliaisyah]

hi all,

im trying to change the background colour according to this range :

if(SPH >= 130, RGB(128,170,255),

if(SPH >= 100 and SPH <= 129, RGB(128,255,170),

if(SPH <= 99, RGB(255,128,149))))

but the half of the data here is correct, the other half of data I have a mix of color again

I'm not sure what is the problem here

[Anil_Babu_Samineni]

Try this?

If(SPB>=0 and SPB<=99, RGB(255,128,149), If(SPB>=100 and SPH<=129, RGB(128,255,170), If(SPH>=130, RGB(128,170,255))))

[iliaisyah]

i try as follow

if(SPH >=0 and SPH <= 99, RGB(255,128,149),

if(SPH >= 100 and SPH <= 129, RGB(128,255,170),

if(SPH >= 130, RGB(128,170,255))))

still not change

[Anil_Babu_Samineni]

Can you convert that into table and see, What is returning and test the values where it fails?