Same colors for same values in chart

[#1]

Hi everyone,

I have a problem with colors in charts

I have multiple charts with different dimensions with same values and I need to show these same values in one color in all charts.

I try to use 'Persistent colors', but it's not work correct.

BR, Andris

[Anonymous]

You have the same dimensions which needs to have the same color ... or the same color for specific values?

[#3]

Same color for specific value:

for example: 2 - red, 3- yellow, 4 -green

[Anonymous]

if you know which charts contain which values you could predefine the colors ... but I guesse this is not what you want, because when adding a value this should automatically be given a color?!

[kji · Accepted solution]

Persistent colors will makes sure tha same value in the same field is always presented with the same color (determined by load order), however if the value appears in more than one field there is no easy way to achieve this. For a limited number of values i guess you could achieve this using colorexpressions if(field='A',Red(),if(field='B',Blue(),...

[#6]

Yes, I try this expressions too, but there was two results: nothing or all chart in black.

See in file charts: Mark 1 & Mark 2

[#7]

I found what was wrong.

Red(),Blue().. not work here

There must be used rgb() function