Bar Chart Colour using Expression

[#1]

Hi Guys

What is the correct syntax for forcing the colour of my pie chart.  Here is my syntax in Expressions>Background Colour:

=If(TravelFlightCompany='BA',vBlue,

if(TravelFlightCompany='Kulula',vGreen,

if(TravelFlightCompany='SAA',vOrange,vGrey)))

Thanks

[pennetzdorfer]

Your expression should work. Do your variables contain equal signs? If not, add "=" to your variables or write variables in your expression like $(vBlue)

Regards,

Florian

[#3 · Accepted solution]

Hi try this...

Expressions>BackgroundColour:

pick(match(TravelFlightCompany, ' BA', 'Kulula','SAA'),
     rgb(0,0,255),
     rgb(0,128,0),
     rgb(255,128,0)
     )

& colours tab >Data appearance color select grey..

Hope it will help u..

regards-bika

[#4]

HI Bika

Worsk well thanks.  Only thing is I am using Dimension Limit, Show Top 5 and Options Show Others.  The Colour of my top 5 have been sey by me, but how do I set the colour for the "Other"?

[#5]

colours tab >Data appearance color select grey fpor "others"..

pls try this..but u cant fix inside the others dim...

regards-bika

[#6]

Hi Bika,

Could youtell how to assign document cal to a document as I have 25 document cals in the server

Thanks