Bar Graph - Colour certain bars specific colours

[#1]

Hi

I have a graph containing a the dimension 'NAME' and and expression that counts the amount of times the name appears in a range of data.

I want to be able to colour two of the bars in the charts. For example the bar with Name X and the bar with name Y.

There are a total of roughly 100 names in my dataset. How do i colour a certain 2?

Is this even possible?

Regards

[rajni_batra]

in the color tab use calculated color

like

if(name-namex,RGB(),

if(name=namey,RGB(),

RGB())

hope to help

[#3]

In the Expressions Tab, expad the Expression used in the Bar Graph and under 'Background Color' use the expression:

=If(Name='<Name1>',Color(6),If(Name='<Name2>',Color(6)))

Replace Color(6) to your desired Color