Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
)