Conditionnal formatting - Block chart

[#1]

Hi the community,

I'm trying to build a block chart made of 40+ blocks. The color of each block will depend wether it's 'yes' (green), 'no' (red)

I wrote the formula (see below) under color tab/dataapperance/calculatedcolor but it doesnt work + it only applies to one dimension and not the 39 others.

if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))

unit A, yes

unit B, yes

unit C, no

unit D, yes

unit E, no

etc

An other pbm I'm facing: the condition is a variable and might change from yes to no every other month.

Does anyone of you know how to proceed ?

Thank you

[rwunderlich · Accepted solution]

In your Expression, click the + sign next to the expression. Enter your color expression as the "Background Color" expression.

-Rob

http://masterssummit.com

http://robwunderlich.com

[#3]

Hi

you  change the colors in the expression tab

As per your Requirement in the expression

if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))