How to fix Colors in a Combo Chart

[danialier]

Hello,

Do you know how I can fix the colors in a Combo Chart where I have multiple lines and bars ? What happens is that when I select a country or another one in a List Box, the colors of all lines and bars from the Combo Chart get changed...

Thanks,

dani

[Nicole-Smith]

On the colors tab, check the box for "Persistent Colors".

[danialier]

Hi Nicole,

Thanks. And how I can assign an specific color to any specific country. I mean I want each country to be colored in an specific color (i.e. Germany in blue, China in red, US in green,...)

[danialier]

· Hi Nicole,

Thanks. And how I can assign an specific color to any specific country. I mean I want each country to be colored in an specific color (i.e. Germany in blue, China in red, US in green,...)

Thanks,

dani

[Nicole-Smith]

On your expression, click the + sign next to it, then for Background Color, you can put an expression like:

pick(match(YourCountryField, 'Germany', 'China', 'US'), rgb(0,0,255), rgb(255,0,0), rgb(0,255,0))

[Clever_Anjos]

I sugest you having an inline table to configure each color to each country and then using your "Color" field as a background color expression

LOAD F1 as Country,

RGB(subfield(F2,',',1),subfield(F2,',',2),subfield(F2,',',3)) as Color

  INLINE [

    F1, F2

    China, "255,0,0"

    Brazil, "0,255,255"

];

[danialier]

Thanks Nicole !

I tried on that what when applying the updates my Combo Chart is showing as message as follows: “Allocated memory exceeded” and chart disappears automatically…. What does it mean ???

Thanks !

dani

[Nicole-Smith]

It most likely means there is something wrong with your expression.  Can you please copy what you have onto here so I can see it?  Or even better yet, post a .qvw file.

[Nicole-Smith · Accepted solution]

Also, here is a working example (attached).

[danialier]

Excellent Nicole !!! it works now. many thanks for your support.

Best regards,

dani