Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a bar chart which shows some negative values and some positive
what I want now that positive values shud be displayed in green color and negative values in red color,
Use background expression something like:
If(Sum(Value)>0, Green(), Red())
thanks ,where shud I put this condition ,
where I have written the expression?
Click the + next to the expression in the chart properties and set a colour expression for the background colour. Something like
If(...your expression here... < 0, Red(), Green())
Check the screen shot. Click on the 'Background Color'.