Hi
Like many challenges with Excel explaining the problem is probably the biggest, so here goes:
I have a number of circular bridge support columns that we surveyed a couple of years ago as the client is worried about the verticality of them. So each column was surveyed relative to a fixed origin and relative to a true vertical from the base of the column. So we have a coordinate at the bottom (VC) and a coordinate at the top (FC). Using this data I have calculated the X-Y difference and from that a vector and a bearing angle as one of the issues could be that if all the columns are leaning in the same direction then we may have a problem as opposed to them all going in random directions, which is less of an issue.
We have been back earlier this year to carry out the same exercise, all the data is calculated and tabulated in Excel, which is OK but what I would ideally want is some sort of chart that shows each column and the direction it is leaning based on the data I have i.e X-Y coordinate, vector and bearing angle. I could then compare the data from the two surveys and see at a glance if there is any trend to any one direction.
I have looked at polar charts, Radar charts and even wind rose charts, but I cant seem to get anything that makes sense.
In would like to see an angle scale (say in 15deg intervals) and each column shown as a point or a line from the origin.
I have attached a sample of the data, this is what the columns mean:
X diff Difference between x coordinate at the bottom of the column
Y diff Difference between Y coordinate at the bottom of the column
Horizontal Vector dist The hypotenuse calculated from the x and y difference.
Horizontal Bearing angle The angle relative to North based on the above values.
Hope someone can help with this
Thank
Tim
Bookmarks