Change bar color in histogram dynamically

Fri, 08 Jan 2016 15:23:56 GMT

Hi All,

Can someone help me to change the color of a particular bar in a chart, according to the user color selection.

I save user selection in some variables, but when I try to set the stored RGB value, it doesn't work.

The table has this structure:

Type, Type_var, Value

type1, v_type1, 6

...

typeN, v_typeN, k

In attach you can find an example of the situation.

Thanks!

Alex

Re: Change bar color in histogram dynamically

Gysbert_Wassenaar — Fri, 08 Jan 2016 19:32:43 GMT

Try this expression for the Background color of the chart expression:

pick(match([Type_var],$(=Concat(chr(39) & Type_var & chr(39) ,',', Type))),

$(=concat( '$'& '(' & [Type_var] & ')' ,',', Type))

)