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.
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)?