Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
No problem.
Hi ,
For the bar chart left axis is there and for the line chart right axis is there in your report.
Now you want the bar chart has to reflect on right axis basis. do you have any relation between
bar & line chart if yes then it will be easy to write the back ground color condition.
Regards
Rajesh Kumar
Hi Settu
it is possible for change the script to have 4 color ?
Paul
Yes, what is the criteria for 4th one?
Hi Rajesh
I am not quite understand what you mean ?
Paul
If GP % less then 15% Black Color
Sent from my iPhone
Try this..
If(GP% > 0.3,Yellow(),
If(GP% < 0.15,Black(),
If(GP% < 0.2, Red(), Green())))
Hi Settu
Can you go back to the org script on 3 Color , this time add a new condition if GP% > 33 % Color = Black
As previous one less then 15% Black Color your script is not work , I can not explain to you why.
Paul
Sent from my iPhone
I did test, it is working for me..
You can adjust the GP% and see 4 Color ?
Sent from my iPhone