Longitude and Latitude not displaying correctly

Discussion created by keriannetwestphal on Jul 30, 2013
Latest reply on Jul 30, 2013 by Wayne_Whitley
Hello - I am new to ArcMap and am very confused as to why this is happening.

I have imported an Excel file with around 3,500 coordinates. The file imports correctly, I can see the data and everything. However, when I choose to display the data, it does not give me the option to change the y-field to latitude. So basically both x and y are displaying longitude.

When this happens, the data all appears off the coast of Africa (I'm working in Long Island... not even close!) and no matter what I do (adding negative signs, switching the columns, etc) the data appears in this region. All of the numbers in my file are saved as numbers (they are decimal degrees), the headings are Longitude, Latitude and Description... I can't figure out why this will not display correctly! Anyone have any ideas?


(I attached the .xls file that is displaying incorrectly).

**EDIT** Upon closer inspection, all the data is appearing directly at the 0,0 point of the world map. I am using the World Mercator (Auxilary Sphere) coordinate system for my data.

**EDIT2** I am able to now choose longitude for x and latitude for y, but the data points are still occuring at the origin...