I have a list of lat/long coordinates in .xlsx format. I imported this table into ArcMap, but when I plot the points, they are not showing up in the proper place. Instead of showing up in South Africa, the points are showing up somewhere the Gulf of Guinea.
In GoogleMaps, when I get the coordinates for the area where ArcMap is plotting my data, I get somewhere around (-0.418588, 2.013222).
Using Add XY data, I am setting the X to longitude and the Y to latitude. I am using the WGS_1984_Web_Mercator_Auxiliary_Sphere coordinate system.
latitude longitude -33.49 18.68 -26.56 25.82 -33.38 20.23 -26.23333 28.13333 -34.31667 19.88333 -26.11667 28.1 -32.36667 27.56667
How can I get these points to show up in South Africa, where they belong, as opposed to in the middle of the Atlantic Ocean?