How to make my chart bar turn yellow when GP% less then 15% ?

[paulyeo11]

	Hi All
	May i know how to make my chart display as below :-
	1. if GP > 30% Dark Green
	1. if GP > 15% <30%  Light Green
	1. if GP < 15% light Yello
	Now all bar are black
	Paul

[paulyeo11]

Hi All

My QV Doc

[mvanlutterveld]

Hi Paul,

I changed the name of your GP% expression to: GP%. In the Background Color attribute of the Sales expression I entered the following nested if:

If(GP% > 0.3,rgb(0,128,0)

  ,If(GP% < 0.15, RGB(255,255,98), RGB(0,255,0))

  )

This resulted in the following:

Is this what you're looking for?

Cheers,

Michiel

[paulyeo11 · Accepted solution]

Hi Sir

Very smart why. Thank it work.now.

Paul