Negative value with different Color in Gauge Chart

[#1]

HI All,

Trying to display Bar chart in a straight table.

Is there any possibility to display positive value and negative value in the same side with different Colors.

[adamdavi3s]

yes using the background formula of the expression (click the + next to the expression on the expressions tab)

if(yourexpression <=0,lightred(),green())

or insert your own rgb colours in there

[stephenedberkg]

HI,

For the percentage values use this formula  as background color

if(yourexpression <=0,red(),green())

for the linear gauge chart set the lower bound is -1 and lower bound color is red

upper bound is 0 and color is green

[Frank_Hartmann]

attached sample might be helpful