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

Occasional Visitor

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 helpScreenshot (269).png

1 Reply
best response confirmed by JKelliher (Occasional Visitor)


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)