Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5)

[#1]

Was wondering how to change the color of a bar chart, depending on whether values are positive or negative...?

Noticed within the "Expressions" tab, you can define "Background Color", but not exactly sure how to use this?

Any tips appreciated!

Kind regards,

Rich

[#2 · Accepted solution]

See example.

For eache expression put

If(Column(1)>0,green(),red())

[#3]

Muito obrigado para isso! exactly what I was looking for, and wasn't sure how to define the "column(1)"

Many thanks!

Kind regards,

Rich

[#4]

Hello,

Can we have a different color for each bar on the chart,irrespective of the value, means even if the adjacent bars have same value they should have different colors ?

Regards