Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in the color tab use calculated color
like
if(name-namex,RGB(),
if(name=namey,RGB(),
RGB())
hope to help
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