This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office/.

Essential vocabulary

Auto update

After you have added your Excel data to a map, you can update the values in your spreadsheet and insert or delete rows and columns. The changes are automatically reflected in the map and pop-up windows.

Aggregate

Depending on your data and choice of Location type, you may be able to take advantage of the aggregate functionality when adding data. Aggregating data is a way to summarize data such that it is easier to analyze and explore. If you choose to aggregate your data, Esri Maps for Office creates an Excel PivotTable and adds this table as a worksheet to your existing Excel workbook. For example, you could aggregate office location data to show total number of employees in each state, as opposed to the individual office locations that might span over multiple cities in a single state.

Areas

Areas are enclosed polygons (many-sided figures) that represent the shape and location of homogeneous features such as states, counties, parcels, and land-use zones.

Basemap

A basemap provides a geographical context, or background, for the content that you want to display in a map. With Esri Maps for Office, you can choose from several Esri basemaps that are hosted on ArcGIS Online. These basemaps include many options that combine road, aerial, and topographic data with a variety of symbology.

Clustering

Clustering in Esri Maps for Office refers to grouping point features within a certain distance of each other into one symbol. This is different from Grouping in Esri Maps for Office where features are grouped by a user-specified column and styled accordingly. Clustering makes the map more readable, makes patterns more apparent, and improves performance of the map.

Coordinate system

Coordinate systems provide a framework for defining real-world locations. In Esri Maps for Office, there are two supported coordinate systems, World Geodetic Survey 1984 (WGS84) and Web Mercator. WGS84 is a geographic coordinate system in which every location on the earth is specified by a set of numbers (coordinates). Coordinates are often expressed as latitude and longitude values. Web Mercator is a projected coordinate system in which locations are identified by x,y coordinates on a grid, with the origin at the center of the grid. Coordinate values in the Web Mercator system generally have 6, 7, or 8 digits to the left of the decimal, and the units are meters. If you are unsure as to which coordinate system you should use, please contact the originator of your spreadsheet or the person who collected the data.

Coordinates

A set of values represented by the letters x and y that define a position within a spatial reference. Coordinates are used to represent locations in space relative to other locations. Coordinates are often shown in latitude/longitude pairs where x coordinates range from -180 to 180 and y coordinates range from -90 to 90, or as values with 6, 7, or 8 digits to the left of the decimal point. When using Esri Maps for Office, these value pairs are often composed of the values from two columns in your data.

Feature

Geographic features are representations of things located on or near the surface of the earth. Geographic features can occur naturally (such as rivers and vegetation), can be constructions (such as roads, pipelines, wells, and buildings), and can be subdivisions of land (such as counties, political divisions, and land parcels). Geographic features are most commonly represented as points, lines, or polygons. In Esri Maps for Office, data that you have added are often referred to as features on the map.

Grouping

Grouping in Esri Maps for Office is the process of placing features in user-specified categories and styling them accordingly.

Heat map

A heat map represents the geographic density of point features on a map by using colored areas to represent those points. The areas are largest and appear hottest where the most points are concentrated together.

Layer

A layer is the way in which Esri Maps for Office visually represents geographic datasets. A layer can be thought of as similar to a legend item on a paper map. On a road map, for example, roads, national parks, political boundaries, and rivers might be considered different layers. When you add Excel data onto a map, Esri Maps for Office creates a layer and displays it in the Table of Contents. Once the layer is created, functionality such as determining visibility, configuring style, clustering features, and creating heat maps are all configurable from the gear icon next to the layer.

Lines

Lines represent the shape and location of geographic objects too narrow to depict as areas (such as street centerlines and streams).

Map

A map displays geographic data and allows you to explore and interact with that data. In Esri Maps for Office, you can add Excel data directly to the map and combine that with additional content from ArcGIS Online. You can then save the map in the worksheet or share the map via ArcGIS Online. Shared maps can be viewed in Excel, on ArcGIS Online, or they can be added to a presentation in Microsoft PowerPoint.

Map Contents

Map contents is a central component of Esri Maps for Office. Map contents displays the list of layers contained in the map and provides the ability to toggle layer visibility, change layer options (using the gear icon next to the layer), move layers up or down in the drawing order, copy a layer, go to a layer, get layer details, or delete a layer. Map contents can be found on the left side of the map when fully expanded. When collapsed, Map contents appears as a small orange box in the top left corner of the map.

Named Range (Excel)

In Excel, a table or named range is an item specifically created by the user of the workbook (and is not equivalent to the spreadsheet). You can see if there are any tables or named ranges in your spreadsheet by clicking the Name Manager button on the Formulas tab of the Ribbon. For more information, see Overview of Excel tables.

Pan (the map display)

Shift a map image relative to the display window without changing the viewing scale. Panning a map can also be thought of as moving the map image in the display window so that you can see different parts of the map. Panning is done with a click and drag mouse action on the map image.

PivotTable (Excel)

An Excel tool used to create worksheets that can be sorted, filtered, and rearranged dynamically to emphasize different aspects of your data. In Esri Maps for Office, a PivotTable is used when adding aggregated data. PivotTables can also be used as input for adding Excel data to a map. For more information, see Overview of PivotTable and PivotChart reports.

Points

Points represent discrete locations of geographic features too small to be depicted as lines or areas, such as well locations, telephone poles, and stream gauges. Points can also represent address locations, Global Positioning System (GPS) coordinates, or mountain peaks.

Table (Excel)

In Excel, a table or named range is an item specifically created by the user of the workbook (and is not equivalent to the spreadsheet). You can see if there are any tables or named ranges in your spreadsheet by clicking the Name Manager button on the Formulas tab of the Ribbon. For more information, see Overview of Excel tables.

Worksheet (Excel)

The primary document used in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows. A worksheet is always stored in a workbook.