5 Replies Latest reply: Jan 14, 2013 6:54 AM by Uday Kumar RSS

    Change Background Color of a bar chart based on some field

    Uday Kumar

      Hi,


      I have an Inline field created in edit script by name consider Fruit.

      It has values like All, Apple, Banana, Orange, Mango, Pineapple.

      I have a database field by name FRUIT.

      These two Fruit and FRUIT are linked in the script like

      All,Apple

      All,Banana

      All,Orange

      All,Mango

      All,Pineapple

      Apple,Apple

      Banana,Banana

      Orange,Orange

      Mango,Mango

      Pineapple,Pineapple

       

      I am using Fruit field in my Listbox as filter and FRUIT as a dimension in the Bar Chart.

      I have applied the background color for FRUIT in the expression in the Chart, background color.

      It is working fine. but when we select any value from listbox like "Apple",

      then only Apple is shown in red color in the chart and other values are shown in the basic blue color.

      But it should show the color defined in the expressions even if user selects any value from Listbox.

      How we can achieve this?