Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. On the Desktop, double-click the XY folder.
  2. Double-click Coordinates_ClimateProtectionAgreementMayors.xls to open the file with Excel.

This Excel worksheet provides a list of cities whose mayors signed the U.S. Conference of Mayors Climate Protection Agreement as of September 12, 2011. This list was obtained from the Climate Protection Center website at http://www.usmayors.org/climateprotection/list.asp. Notice that the worksheet also contains the latitude and longitude of the cities in decimal degrees.

  1. Close Excel.

Displaying XY Data

Now that you have observed examined the tabular data in Excel data, it is time to display the XY data of citiescity locations on a map.

  1. Within the XY folder, double-click the XY.aprx project file to open the project in ArcGIS Pro.
  2. In the Catalog pane, double-click the expand the Folders folder and double-click the XYTutorialData folder..
  3. Expand the XY folder.
  4. Expand Double-click the Coordinates_ClimateProtectionAgreementMayors.xls Excel file to expand it and view the individual worksheets.Right-click Sheet1$ into the Map Display
Note

Note than an entire Excel file cannot be added to a map, only a worksheet within the Excel file.

  1. In the Contents pane, right-click the Sheet1$ table and select Display XY Data.

...