requirement

[Anonymous]

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,

[tresB]

Use background expression something like:

If(Sum(Value)>0, Green(), Red())

[Anonymous]

thanks ,where shud I put this condition ,

where I have written the expression?

[jonathandienst]

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())

[tresB]

Check the screen shot. Click on the 'Background Color'.