Making a bar chart red when above x money

[nickploeg1998]

Hii,

I have a bar chart with different projects. There are different costs in every project, the total of all those costs is shown in the chart per project. 

Now I want a red line at the average + 25%. I didn't know how to do this, so I calculated it myself. So the red line is €45.574.

Now I want the green bar to become red when its over the €45.574 euro's. How do I do this? I try'd a lot of things but nothing works the right way.

[Vengatesh · Accepted solution]

Expand the first expression and add a condition to the background colour option.

If(Sum(FieldName)>45.574,RGB(255,0,0),RGB(0,255,0))