3 Replies Latest reply: Jul 17, 2017 7:57 AM by Michael Graham RSS

    Chart colour based on values

    Michael Graham



      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



      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