change color to column in a bar chart

[#1]

Hi all,

this is my problem: i want to do a conditional formatting in a bar chart, but i'm not able. I want green column if value is greater than a 38 and red column if value is lower than a 38

thx to all

[#2 · Accepted solution]

Change your expression to sum(valore)

There is a background color option and that is where you put your color logic.

=if((sum(valore)>38),red(),green())

That should do the trick.

[spividori]

Hi.

is like saying wms. See the image.

In the expression:

in the background color:

Regards.

[#4]

I put the attachment on the reply.

Check it again.

the standard sum goes in the normal expression editor.

[its_anandrjs]

Hi,

See the attached sample file

And let me know

HTH

Regards

Anand