Conditional expressions mess up Chart Colors

[pennetzdorfer]

Hey,

I've a simple bar chart containing 3 expressions. For each of them I need a specific color, which I've defined in the "Colors" tab.

Expression 1 - green

Expression 2 - yellow

Expression 3 - red

Now I set a conditional show statement for expression 1. In case the condition doesn't apply, expression 1 disappears ... so far so good.

But unfortunately the colors for the other expressions change (expression 2 - green,  expression 3 - yellow) ...

Do you have any idea how to keep the predefined colors for each expression?

(I've already checked/unchecked "Persistent Colors" - but it doesn't work in this case)

Thx!

[whiteline · Accepted solution]

You can assign colors manualy.

Expand each expression and for Background Color Type:

=color(N)

where N is the number of expression (it's also the number in the color table).

[pennetzdorfer]

Great, thanks a lot!  I didn't know that function