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/.
Once you have added a map to your spreadsheet, you can add layers to it. To add layers from the data in your spreadsheet, click From worksheet in the map ribbon.
Data allows you to choose the data in your spreadsheet that will be used to create the map. Use the dropdown menu to choose from tables and named ranges detected in your spreadsheet. To select a new cell range, click 'More...' in the dropdown menu and click the 'Cell range' button.
Location type determines how your data will be mapped and controls what is displayed in the carousel. If you select address, city, or lat/long, your locations will be mapped as points. If you select state, province, or other area location type, your data will be mapped as polygons. You can also map your data to custom location types, such as park boundaries or sales territories, that aren't included in the default list. To add custom location types, click on 'More...' in the dropdown menu and add a new location under 'My locations'. Refer to the section on location types for more information.
Style by column lets you pick which column will be used to compare the points, lines, or areas on your map. For example if you want to compare all the stores in a franchise based on sales, you would choose the column that has the sales information. The carousel will display different ways you can compare the records on the map. Typically you can compare records by varying the size or color of icons. To simply map your records without comparison, choose None in the Style by column dropdown menu.
After selecting your data source, you will be presented with the carousel of choices shown above.