How Dynamically change BO Dashboard background color with each plant

[Former Member]

Hi,

In below Dashboard user want to see different color background for each plant. Whenever they select different plant background color should be changed. Please can you suggest how can this achieve.

[former_member194862 · Accepted solution]

Hi Pawan,

you can harcode the hex codes of the colors that you want to the spreadsheet.

The moment you select the plant then the background of the chart will be changed.

Regards,

Amit

[Former Member · Accepted solution]

Hi Amit,

please ease can you send screenshots how can I do hardcore. 

[former_member182541 · Accepted solution]

Take a look at the attachment

cOLOR.txt.zip

[Former Member · Accepted solution]

Sorry Suman, your attachment don't open. If possible just send screenshots.

Thanks,

Pawan

[former_member182541 · Accepted solution]

Have taken the plants in A,B,C,D manner and specified with hexadecimal color codes.

Check the combo box properties and their mapping in the general tab.

Then add a background and select background color --> Choose the cell below more color and select the cell where the combo box through's the value.

Preview and change the combo box value and let me know any difficulties on this.

[former_member182541 · Accepted solution]

Have you checked my screenshots ?

[Former Member · Accepted solution]

Hi Suman,

I'm not using combo box .. my source is BEx query and I'm using Query prompt selector...

[hungpham17]

Hi Pawan Kumar,

Firstly, you should use an component and put them as background of dashboard. For instance, I used an BACKGROUND component.

Secondly, you should put all components above/in front of BACKGROUND component and specify no background for their components.

Thirdly. you should prepare Source and Destination as below exhibit picture. Color of BACKGROUND component is pointed to "C6" cell (this is destination value of combo-box) based on correspondingly selected Plant from combo-box.

Hopefully, it is useful for you

Thanks

Hung

Message was edited by: Hung Pham

[Former Member]

Hi Pavan,

You can try as below.

Take the Background sheets based on number of Plants you are having.

Use the dynamic visibility behaviour for the Backgrounds.Based on the selection of each plant make the related background as visible and others are invisible.

To identify the plant selection you can use "Insert Selected  Item" option under Selection to know the which plant has been selected.

Hope it helps.

Best Regards,

Venkat

[former_member194862]

In the cell A1 you can have the hex code of the color that you want.

So if you want to dynamically change it then you have get the hex codes of the colors and map them to a combobox and depending on your selection you can get the color changed.

[Former Member]

Hi

Want to change background color.. not graph..

[Former Member]

If I understand right, you are trying to change the background color for the entire canvas and not just the components. You can add a Background component to the canvas and bind the background color to some spreadsheet cell as I have done in the attached sample dashboard.

To open the dashboard change the extension to XLF.

Regards,

Niraj

Background color.txt.zip

[Former Member]

TOP TIP : If you find it difficult working with hex codes for colours you can also bind to a cell containing the RGB colour code in the form (R,G,B)  so for 100% red have a cell containing (255,0,0)  Note when inputting the value into the cell you may need to prefix the RGB value with an apostrophe ' to prevent Excel interpreting your input as a number.