Create a HeatMap Grid in a Scatter Plot Diagram

[#1]

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!

[a_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