How to make my chart appear 3 color ? Now only 2 color

[paulyeo11]

Hi All

Now my Bar chart if more then 30% it turn light Blue. below 30% bar color Blue.

Now i like to make 2013 Bar now Blue change to red color ? when GP % below 20% Bar color change to red.

I will enclosed my QV Doc in my next posting

Paul

[paulyeo11]

Hi Settu

I think it is possible only have 3 Color .

30% yellow

< 20% red

In between green

If 4 Color is not possible , as there are 2 in between.

Paul

Sent from my iPhone

[paulyeo11]

I think 3 Color is good enough , if imagine traffic light have 4 Color , very confuse.

Sent from my iPhone

[PrashantSangle]

Hi,

Can you give your all conditions??

Other wise What Settu Suggested must work.

Regards

[settu_periasamy]

I think it is possible..

first , if GP% < 30 , Yellow Else

if GP% < 15 , Black  ( suppose your  GP%  value < 20 this won't check) Else

If GP% < 20, Red , Else

Everything should be Green..

[settu_periasamy]

Agreed.

[paulyeo11]

Okay case closed

Sent from my iPhone

[paulyeo11]

Hi settu

In case you avaiable , can help to take a look of below posting :-

Re: Convert 3 color script to 4 color for GP%