Making scatter with only known begin coordinates, angle in rad. and length

In your case endpoint coordinates (assuming angle is measured anticlockwise, starting from x axis) are:

x = xstart + length*cos(angle)
y = ystart + length *sin(angle)

so if your 412 and 1333 are in cells C1 and D1
and length and angle in A2 and B2
write in C2:=C$1+A2*COS(B2)
and in D2:=D$1+A2*SIN(B2)

you can write next pairs length, angle below in columns A and B and copy formulas from C2 and D2 down

now select columns C and D and insert scatterplot.

1) below/above (but right/left is OK I assume) - so angle is probably measured clockwise.
Keep X formula unchanged, and modify Y:
y = ystart - length *sin(angle)
so:
D2:

Formula:

Please Login or Register  to view this content.

conecting lines:
you need:
center coordinates
first point coordinates
center coordinates
second point coordinates
center coordinates
third point coordinates
etc.

I do not know layout of your data. So let's assume is the one I used before
May be easy way will be add empty row below each pair (length, angle) and then copy formulas from C2:D2 to columns C and D in these empty rows. As in added rows columns A and B are empty the formulas in C and D will return coordinates of center.