color

[Anonymous]

I have a multi box and a chart. The multi box allows the user to select various items from a drop down box. H, P, N and so on

I would like to change the color of the in the chart based on what the user select.

Ex: if the user select H, I like the H info in the Chart to be red. If P then I like the P info to be Blue and etc.

How can I do this?

Thanks.

[Miguel_Angel_Baeyens]

Hello,

Go to the chart properties, Expressions, expand using the [+] sign at the left of the expression you want to color, select "Background Color" and set something like

Pick(Match(FieldInMultibox, 'H', 'P', 'N'), LightRed(), Blue(), Green()) 

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Check this application, This works when user select one value.

This is also very similar solution suggested by Miguel.

Hope this helps you.

- Sridhar