Help with charts

[CivilPengineer]

I want to use the charts to do the following:
I have data where each data point has an "X" value, "Y" value (co-ordinates) and a "UR" value. These are in three columns, each data point is on a seperate row. Here is some dummy data (real data is a lot bigger):

What I want to do is make a chart where it shows the location of each data point in X,Y, and then colours the point green if the "UR" value for that point is less than or equal to 1, and red if it is greater than 1.

It will look something like this (although I had imagined using a chart to do this, not cells in the workbook)

Can anyone help? I was thinking I might be able to do something with the 3d surface chart but I can't get it to work.

Any ideas much appreciated!

 

[Steve=True]

That is so awesome!!!

thanks for sharing the context. Sometimes you assist and do not know the application.

This is really cool!

Glad you are taking it and running with it

Let me know if you need any more help!