I'd like to visually add (graph) vectors, up to three of them. I'd prefer to simply add them as polar coordinates, although I can easily convert them to rectangular coordinates. I'd like Excel to graph one vector after another, adding the tail of each vector to the head of the previous vector (or the origin). At the end, I'd like Excel to draw a vector from the origin of the graph to the head of the last vector and give the resulting polar coordinates (converting as required). In the following table I show how I'd like to format the initial polar coordinates -- it also shows the calculated x/y end points for the same line stretching from the origin. I have four vectors in this sample table just so that I can check my x,y calculations.
Vectors
Mag Angle Ref Ang x y
100 50 50 64.2788 76.6044
150 170 10 -147.7212 26.0472
50 185 5 -49.8097 -4.3578
50 275 85 4.3578 -49.8097
The code for the Ref Angle on the first line is:
=IF(B3<90,B3,IF(B3<=180,180-B3,IF(B3<=270,B3-180,IF(B3<=360,360-B3,"ERR"))))
The code for x on the first line is:
=IF(OR(B3<90,B3>270),ROUND(A3*COS(RADIANS(C3)),4),ROUND(A3*COS(RADIANS(C3))*-1,4))
The code for y on the first line is:
=IF(B3<180,ROUND(A3*SIN(RADIANS(C3)),4),ROUND(A3*SIN(RADIANS(C3))*-1,4))
Bookmarks