Bar chart going below '0'

[#1]

Hello there,

is there a way to show this graph with all the red columns (minus 0) to be graphically below '0' and only the 2 green columns as they are right now.

thanks for your help

JP

[Mark_Little · Accepted solution]

Hi,

It should be possible. Are you using the FABS() function to make the values all Positive?

If so you could add a expression to the background colour.

In the chart properties > expressions. Press the little plus symbol click on the Background colour

Add the below in the definition

IF(SUM(Value) > 0, Red(), Green())

You could change the colour to RGB values.

Mark

[#3]

Thanks Mark, it was the Fabs

now it is ok