Creating polygon from spreadsheet

neuwirthe shared this question 3 years ago
Answered

Entering x and y coordinates as, say (1,3) in a column of the spreadsheet creates points in the Graphics view.


I would like to create a polygon from the points, and doing it manually is too tedious because there are by far too many points for that. Is there a way of creating the polygon automatically?

Comments (3)

photo
1

see comments in the attachment

photo
1

My problem was that I could not paste this from another spreadsheet.


But just pasting the x and y coordinates into columns A and B and then using the formula (A1,B1) in colums C and copying down created the point data needed.

photo
1

as rami's suggested, you can use:


  1. Polygon[Zip[(a, b), a, A1:A1000, b, B1:B1000]]

photo
© 2021 International GeoGebra Institute