Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In a histogram of the charges, I have positive and negative values values; according to the representative. The X axis represented the representatives and the Y axis represented the amount of charges.
In this histogram, I want to display the amount (bars) up in green, and negative values in red.
Is this possible?
U have a + sign next to the expresion u have written in the expression tab, if u click this u will get some more options.
Among that select Background color and writre the expression
=if(urexpression>0,green(),red())
please note urexpression is whatever expression you have written in the expression tab.
Hope this helps.
-Sundar
You can set the Background Colour of an object using an expression, you could say If(X>0,Green(),Red()) for example.
Hi James,
Thank you for your replay . Can you explain more about this pleaase
U have a + sign next to the expresion u have written in the expression tab, if u click this u will get some more options.
Among that select Background color and writre the expression
=if(urexpression>0,green(),red())
please note urexpression is whatever expression you have written in the expression tab.
Hope this helps.
-Sundar
Thornofcrowns ,Sundarakumar Both of them gave the answer what u want
if u got what u want mean close the thread
Nothing to Explain if u r not giving colors in background all the bars are in single color only
now u want to show positive in green and negative is red mean then u have to give in expression->background
if(sum(sales)>0,green(),red())
what i am telling for single dimension and single expression