3 Replies Latest reply: Jul 17, 2017 7:57 AM by michael graham RSS

    Chart colour based on values

    michael graham

      Hello

       

      I am creating a bar graph and I am looking to change the colours if they certain bar reach a certain level

       

      Its split into 2 groups

       

      A,B -  Blue

      C,D - Red

       

      But I want to make it so that if A or B reach 5 they change colour

      same with the rest

       

      i.e.

      IF (A => 5 rgb (50,50,100), rgb(0,0,100))

      If A reaches 5 or more change colour otherwise stick with being blue

       

      Then same with the rest

       

      If you could help it would be appreciated

       

      Thank you