How Do I choose the bar's colour?

[#1]

Hi,

I have a bar graph on that I would like to choose the bar's color for each expretion...

Someone could hepl me with this?

I don't like green colour so I would like to change it...

Regards,

Fernando Toro

[swuehl · Accepted solution]

Open the background color attribute expression by clicking on the small plus sign next to expression label on expression tab. Then enter a color expression like

=ARGB( ...)

=LightBlue()

=LightRed()

...

etc.

Just have a look at color functions in the help.

Alternatively, use the Colors tab in chart properties to use the dialogs to set color palette (which will be used by expressions).

[engishfaque]

Dear Femando,

Object Property > Expressions > Click On + Symbol beside of your expression > Select Background Color > Write your expression with color code, such as given below

=If(Country = 'Taiwan', RGB(255, 0, 0), If(Country = 'China', RGB(0, 255, 0), RGB(0, 0, 255)))

OR

=Pick(Match(Country, 'China', 'Taiwan', 'Indonesia'), Red(), Green(), Blue())

Kind regards,

Ishfaque Ahmed

[amit_saini]

Hi Fernando,

Can be done in 2 ways:

1. Script Side : You can use below script :

set vColorActDirectLabor = 'rgb(141,170,203)';

set vColorAOPDirectLabor = 'rgb(252,115,98)';

set vColorActIndirectLabor = 'rgb(187,216,84)';

set vColorAOPIndirectLabor = 'rgb(255,217,47)';

set vColorAct%DirectLaborofRevenue = 'rgb(102,194,150)';

set vColorAOP%DirectLaborofRevenue = 'rgb(229,182,148)';

Later call them in Background Color like below:

2. Front Side :

Simply define color in Expression Background color

e.g:

=if(Plant='KGZ',rgb(141,170,203),if(Plant='KCC',rgb(252,115,98),if(Plant='KRO',rgb(187,216,84),if(Plant='KBR',rgb(255,217,47),if(Plant='KCQ',rgb(102,194,150),

if(Plant='KSH',rgb(229,182,148),if(Plant='KKS',rgb(231,138,210),if(Plant='KJP',rgb(179,179,179),if(Plant='KBK',rgb(166,216,227),if(Plant='KIS',rgb(171,233,188),

if(Plant='KSI',rgb(27,125,156),if(Plant='KMX',rgb(255,191,201),if(Plant='KBO',rgb(77,167,65),if(Plant='KBL',rgb(196,178,214),if(Plant='KOF',rgb(178,36,36),if(Plant='KOC',rgb(0,172,172)

,if(Plant='CWC',rgb(190,108,44),if(Plant='KUS',rgb(105,84,150),if(Plant='KLA',rgb(132,140,140),if(Plant='KUK',rgb(24,101,222)

,if(Plant='KUL',rgb(333,222,111),if(Plant='KTX',rgb(111,241,131),if(Plant='KZC',rgb(24,25,123))))))))))))))))))))))))

Hope this will help u !

Thanks,

AS

[#5]

Thank you,

Do you know what default colour RGB use QlikVier for blue and red?

Regards,

Fernando