Force color according of value

[mromrod22]

Hi,

Is possible, some path of force a color according the value of field? Explain me:

I have a composed bar char create with two small chars togethers, but the colors are distinct in legend (same legends, diferent color). One mini-char show data of 3 values, and the other, show data for 2 values.

Bar Char 1:

• A - Color blue
• B - Color red
• C - Color green

Bar Char 2:

• A- Color blue
• C- Color red

I want force colors so that each value have a defined color.

Any idea?

Thanks.

[vinieme12 · Accepted solution]

Against the expression click on the '+' sign to expand it and reveal formatting options

Double click on Background Expression and add expression as

=Pick(Wildmatch(Bar,'A','B','C'),blue(),red(),green())

if you have separate expression for each bar then add expressions to each of them separately

for example for Bar A background expression = blue(); Bar AB background expression = red();Bar C background expression = green()

[mromrod22]

Perfect brother, success! Very thanks.