Sorting coordinates of a rectangle (or square or any closed form) in excel clockwise or anti-clockwise when input coordinates are not in any order

[Sunny Baggu]

Hii , Greetings!
In excel, I have points or coordinates of rectangle or any closed shape (example rectangle, square , L shape ).
However the given points or (x,y) coordinates are not in any specific order.
The available points could be in any numbers (including corner points and inline points too).
Then how do I sort the coordinates and plot a rectangle or closed shape in excel chart.
Sample coordinates are given below:

	Coordinates of closed shape
Node No.	X (m)	Z (m)
11812	9	0
11815	18	0
11957	36	18
12033	0	27
12050	36	27
123	0	36
101	9	81
11810	0	0
12261	18	81
12270	27	81
12279	36	81
12077	36	36
230	0	45
1209	36	45
12105	0	54
12113	36	54
234	27	0
324	36	0
11856	0	9
11868	36	9
11939	0	18
12123	0	63
876	36	63
1220	0	72
1222	36	72
12254	0	81

 

[JGordon11]

Add an angle column like I did in column c, then sort the table by the angle column, and plot the sorted table x and y columns. If you want to connect the starting and ending nodes, repeat the top sorted coordinate at the bottom.

SortCoordinates.xlsm
	A	B	C	D	E	F	G	H
1	X	Y	Theta
2	0.11543	0.993316	1.455108		-0.87791	-0.47883	-2.64227
3	-0.87467	0.484711	2.63556		-0.8174	-0.57607	-2.52768
4	0.017786	-0.99984	-1.55301		-0.74832	-0.66334	-2.41632
5	-0.74832	-0.66334	-2.41632		-0.46047	-0.88768	-2.04932
6	-0.23961	0.97087	1.812757		-0.38566	-0.92264	-1.96671
7	0.422531	0.906348	1.13456		-0.38533	-0.92278	-1.96637
8	-0.21754	0.976052	1.790086		-0.13949	-0.99022	-1.71075
9	-0.65893	0.752205	2.290191		0.017786	-0.99984	-1.55301
10	-0.13949	-0.99022	-1.71075		0.169118	-0.9856	-1.40086
11	-0.38533	-0.92278	-1.96637		0.644842	-0.76432	-0.86998
12	-0.87791	-0.47883	-2.64227		0.749335	0.662191	0.723739
13	-0.46047	-0.88768	-2.04932		0.67137	0.741122	0.83474
14	0.644842	-0.76432	-0.86998		0.422531	0.906348	1.13456
15	-0.38566	-0.92264	-1.96671		0.11543	0.993316	1.455108
16	0.67137	0.741122	0.83474		-0.12801	0.991773	1.699158
17	-0.8174	-0.57607	-2.52768		-0.21754	0.976052	1.790086
18	0.169118	-0.9856	-1.40086		-0.23961	0.97087	1.812757
19	0.749335	0.662191	0.723739		-0.65893	0.752205	2.290191
20	-0.12801	0.991773	1.699158		-0.87467	0.484711	2.63556
21
Sheet3

Cell Formulas
Range	Formula
C2:C20,G2:G20	C2	=(-1)^(B2<0)*ACOS(A2/(A2^2+B2^2)^0.5)

 

[JGordon11]

Note that if your shape is not centered at (0,0) the formula in C2 becomes a bit more complex:

=(-1)^((B2 - AVERAGE($B$2:$B$20))<0)*ACOS((A2 - AVERAGE($A$2:$A$20))/((A2 - AVERAGE($A$2:$A$20))^2+(B2 - AVERAGE($B$2:$B$20))^2)^0.5)