Adding Colors in a Bar Chart

[#1]

Hi,

I have a small query - can I have differnt colors in a bar chart depending on the value of the dimension?

FIRM REVENUE

A 100

B 110

Client 98

D 95

If I present this data with a bar chart, Can I have a different color for 'Client'?

[#2]

hi umang,

in the expressions tab use

if(firm='client',green()) in case u have firm as dimension

thanks

[#3]

hi umang,

in the expressions tab under background colour use

if(firm='client',green()) in case u have firm as dimension

thanks

[sathishkumar_go]

Hi

go to Chart --> Properties-->Expression-->BackgroundColour

In BackGroundColour write if(FIRM = 'Client',rgb(198,222,255))

-Sathish

[#5]

Hi and thanks to all for quick responses,

But I still can't get it

I have attached a file if someone will be kind enough to update it and tell me

THANKS

[#6 · Accepted solution]

hi,

pls check the attached application

hope this works for u

thanks

[#7]

Thanks a lot tauqueer - you saved my day as usual