3 Replies Latest reply: May 17, 2018 12:26 PM by Robert Marr RSS

    Colour scatter points relative to scatter points

    Robert Marr

      Can any one show me how to colour the scatter points on this chart based on the following rules

       

      1. If points are in top right quadrant then colour Green

      2. If points are in bottom right then colour Red

      3. If points are in bottom left then colour Orange

      4. If points are in top left then colour blue

       

       

      Bare in mind the reference lines are set relative to a percentile so will move as and when new data is added.

       

      Ideally if someone could provide the completed solution and reattach the file so I can see how you've done it it would be much appreciated.