1 Reply Latest reply: Jul 28, 2015 7:11 AM by Azam Mullick RSS

    Create a HeatMap Grid in a Scatter Plot Diagram

      Hi,

       

      I am looking for a way to create a heat map in a scatter plot diagram. Is there a way I could add an expression to change the grid colors of a scatter plot diagram?

       

      The below picture depicts what I would like to do more or less:

       

       

      The below picture depicts what I currently have. I would like to change the grid colors in the background according to an expression i.e. below 0 the grid colors must be red.

       

       

      Any help would be greatly appreciated.

       

      Thanks!

        • Re: Create a HeatMap Grid in a Scatter Plot Diagram
          Azam Mullick

          Hi,

           

          I'm not sure how to change the grid colour by expression but my suggestion would be ...

           

          1) Use a background image to 'colour' the chart or...

           

          2) Rather than changing the background colour how about conditionally formatting the data points themselves - so if they are below your threshold they are red, otherwise grey (for example)?

           

          Thanks,

          Azam