5 Replies Latest reply on Aug 21, 2018 10:51 PM by siva Nageswara Rao

    colour bars in a side-by-side graph using a calculated fiels

    Caireen Zaina

      Hi All

      Hope you are all having a good week.

       

      I am trying to work out if I can colour one set of bars in a side-by-side graph with a calculated field.

       

      it is a Target v Actuals Graph and I would like the actuals to change colour based on a simple formula where if they are less than the target they are green if they are greater then they are red.

       

      Does anybody have any ideas on this?

      I have attached the workbook of where i have gotten to with this...

       

       

      Thanks

      Caireen