Skip to Content
author's profile photo Former Member
0
Former Member

How Dynamically change BO Dashboard background color with each plant

Posted on Nov 25, 2014 at 01:29 PM 175 Views

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.

Capture.JPG (36.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Amit Anant Kulkarni
    Amit Anant Kulkarni
    Posted on Nov 25, 2014 at 07:08 PM
    2

    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

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Hung Pham
    Hung Pham
    Posted on Nov 28, 2014 at 09:43 AM
    1

    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


    SCN.png (33.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 01, 2014 at 06:46 AM

      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

      Capture.PNG (4.1 kB)
  • author's profile photo Amit Anant Kulkarni
    Amit Anant Kulkarni
    Posted on Nov 26, 2014 at 02:40 PM
    0

    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.


    Hex codes.png (201.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 09, 2014 at 05:27 PM

      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.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.