barchart - negative value in different color, how?

[jim_chan]

Hi guys,

I have created a bar chart, has negative value. all i want is have another color for the negative value.

How to do that??

My expression is just as simple as sum(total_sales), at the moment.

Rgds,

Jim

[arulsettu · Accepted solution]

in expression->background color

try this

if(sum(Sale)>0,green(),red())

[jim_chan]

ar!!!!! silly question! i knew this... but thanks anyway!