Calculated Bar Colours on Chart

[#1]

I have a chart with a target. If the sum of the field is greater than 98 I want the bar to be green if its below this I want it to be red. I have used this calculation but it doeswn't work, is this possible?

if

(Sum ([Yield %]) > 98,Green(),Red())

[#2 · Accepted solution]

Have you insert the code into "Background colour", the sub-point underneath dimension- and formula-name?

See attached example.

[#3]

Hi,

see the attached example.

Good luck!

Rainer

[#4]

Thanks guys. As I posted the question i tried the background colour under expressions and it worked. I was doing it on the colour tab originally.

Thanks for your replies

[#5]

Hi,

Can you please send me the attachment in an email as i am unable open the file downloaded from here.

Thanks

Arun

[#6]

Thanks Rainer, that saved me a lot of time., great example