Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Mark, it was the Fabs
now it is ok