XY Scatter with colour of points showing third variable?

[Sosoomii]

Hi,

I’m sure this has been asked many times before but despite my best efforts I can’t find anything.

I would like to plot a position of a car around a town (x = longitude and y = latitude co-ordinates) with the colour of the points showing the speed at that position.

e.g.
X Y Z
Lat. Long. Speed
0 0 2
1 0 2
2 0 3
2 1 2

Is it possible to put conditional formatting on the xy point based on the value of Z? If so, how? If not, any alternatives?

Thanks in advance!

[Andy Pope]

You need to create a series for each speed.
Use formula to determine whether speed matches that of series and then output Y pos or NA().

[Sosoomii]

Thank you!