Color a single bar

[gfisch13]

Hi - I have a bar chart that is showing the aging of cases,

I want to change the color of the 120+ bar to red.  I've tried a conditional statement in the Background Color section of the expression, and have also tried the same conditional on the colors tab. My expression is below and the chart is attached.

Not sure what I'm doing wrong.  Thank you!

I've tried both of these:

=If(Buckets = '120+')

=If(Buckets = '120+', RGB(255,0,0))

[settu_periasamy · Accepted solution]

Your expression should work.

Can you remove the 'expression' in the Colors tab and try?

Can you share the sample?

[gfisch13]

Thanks for the response - what I've come to find out is that the formula is in fact working, but not on my machine.  If I pass the QVW file to a coworker it works, why would that be?

If I wanted to color other bars in my chart, what would be the easiest way to nest those functions?

[settu_periasamy]

George Fischetti wrote:

Thanks for the response - what I've come to find out is that the formula is in fact working, but not on my machine.  If I pass the QVW file to a coworker it works, why would that be?

Try to recreate the chart.

If I wanted to color other bars in my chart, what would be the easiest way to nest those functions?

Did you try the Multicolored option? If you want the specific colors in a bar, you can try with Pick(Match(..)..) instead of nested if.