Specifying a colour for each bar in a chart

[starter888]

Hi everyone

I am trying to colour each of the bars a specific RGB colour.

Can someone help with an expression I can use to specify the colours? Each bar is a result of a % of count e.g. # of dogs, # of cats, # of rabbits

Each animal/category needs to be a specific colour which I have the RGB for.

Thanks in advance 🙂

[arulsettu]

Hi 

Under Appearance -> colour and legend 

Choose Dimension

and write a calculated expression like

if(dimension='Cat',red(),

if(dimension='Dog',blue(),

if(dimension='rabbits',green(),

if(dimension='Bull',Brown()))))

[starter888]

Thanks for replying.

It's saying:

[arulsettu]

it just a sample code

you need to change the dimension 

can you post your app. 

[starter888]

I don't know how to post my app

[Channa]

you have to close IF 

If(dim='Cat',red())

[arulsettu]

Click reply and left corner there is option to choose your qvf file.

[starter888]

Had to zip as wasn't accepting qvf - hope it works

[arulsettu · Accepted solution]

Check the attachment and change the colour as per your need