Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
BI Consultant
Check this application, This works when user select one value.
This is also very similar solution suggested by Miguel.
Hope this helps you.
- Sridhar