CivilPengineer
New Member
- Joined
- Feb 20, 2012
- Messages
- 12
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!
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!
