How do I get individual points to be specific colours on scatter graphs?

[JKelliher]

Essentially I would love to know how to achieve a scatter graph like this with conditions for the colour of points depending on the number. E.G 45 - 65 is Light Green etc

Thanks for any help

[#2 · Accepted solution]

@JKelliher 

One way to do this is to create a separate series for each range of values.

So in your example. all values in the range 45-65 should be in a column of their own (or row, depending on your data layout)