Create a map

You'll create a map using an Excel spreadsheet so that you can quickly visualize the salon data. You'll start by plotting salon locations on the map and styling these points according to revenue so you can easily see how each salon is doing. Next, you'll add a layer to the map to show the locations of potential new customers whose contact information you collected at the Women's Show. You’ll style the layer to highlight key information about the customers. Finally, you'll configure pop-ups to display detailed information about each feature on the map.

Map business locations

To begin, you'll create a map from a spreadsheet of salon data. Then you'll modify the salon symbols to style them according to revenue.

  1. Download the SalonCustomersOttawaArea.xlsx Excel spreadsheet.
  2. Open the spreadsheet in Microsoft Excel.

    The spreadsheet contains two tabs—one for each worksheet. The salons tab has information about the salons, and the new customers tab has all the contact information that you collected at the Women's Show.

  3. If necessary, click the salons tab to make it the active worksheet.

    Salons tab

    Each salon location has its own row that contains fields for the salon name, manager's name, salon address, city, province, and phone number, as well as the salon's revenue and profits for the current year. To add data to a map, it must contain at least one location-based attribute, such as address data or longitude and latitude values. You'll use the address fields to plot the salon locations on the map.

  4. On the Excel ribbon, click the ArcGIS tab to display the ArcGIS tools.

    ArcGIS tab

    Note:

    If you don't see the ArcGIS tab, download ArcGIS for Office. If you've already installed ArcGIS for Office, see What's new in ArcGIS for Office. or Frequently asked questions for a possible solution.

    Before you can use the tools, you must first sign in to an ArcGIS organizational account (or an ArcGIS Enterprise organizational account).

  5. On the Excel ribbon, on the ArcGIS Maps tab, click Add Map.

    Add Map button

    The Map 1 window appears.

  6. In the Map 1 window, click Sign In and sign in to your ArcGIS organizational account.
    Note:

    If you don't have an organizational account, you can sign up for a free trial.

    The Map 1 window updates with a blank map and the layer list open. You have not added any layers yet, so the list is empty. At the bottom of the Layers pane, the Add from Excel and Add from ArcGIS buttons allow you to add data to the map.

    The other tools in the Map group are unavailable until you create at least one map. With these tools, you can find, arrange, and synchronize maps in your worksheet.

  7. Click Add from Excel.

    Add data from Excel.

    The Add from Excel pane appears.

    ArcGIS for Office provides two ways of adding data from Excel: from a table or a cell range. You will add the salon information as a range of cells in the spreadsheet. The first row in the salons spreadsheet contains headers for the columns. You want to preserve these as attribute field names, which will help you style the map later.

  8. In the Dataset - Table drop-down menu, click Select a cell range.

    Data format cell range

  9. In the salons worksheet, select the range of cells from cell A1 to cell H6.
    Tip:

    You can click the first cell in the range and press the Shift key while you click the last cell in the range.

    Selected range of cells

    The selected cells are surrounded by a green border and the cell range appears under Dataset.

  10. In the Map 1 window, in the Add from Excel pane, confirm that the First row contains headers box is checked.

    First row contains headers checked.

    Next, you'll specify the mapping options and confirm the location information for the salons.

  11. For Location Types, choose Address.

    This field indicates the type of location-based data that you're providing, such as street addresses or latitude-longitude coordinates. In this case, the selected cells contain address data. When you create a layer from addresses, corresponding locations are determined using the default locator set by your organization's administrator.

    Note:

    Geocoding addresses uses ArcGIS credits. To learn more, see Understand credits.

    Several of the mapping options are automatically selected depending on the default settings of your ArcGIS organization and the data in your spreadsheet. However, you must still confirm that the location information is appropriate for your map. For example, the salons are located in Canada. If the default country for your account is the United States, you must choose the correct country (Canada) to ensure that your map displays the features properly.

  12. Under Location types, for Country, choose Canada.
  13. If necessary, click Multiple columns and verify that the location fields were mapped correctly to the corresponding columns in your spreadsheet.

    Country and Multiple columns options

    Note:

    The salons spreadsheet doesn't have a column with values for Postal or Country Code. The None value for these columns is acceptable because the software has enough location information to properly map the salons without these values.

  14. Click Add to map.

    The salon locations appear on the map.

  15. Click the Layer options button.

    Layer options button

  16. For Active layer, confirm that the cell range is $A$1:$H$6.

    Active layer set to the cell range.

    Next, you'll choose a style for visualizing this data in the map. ArcGIS for Office provides many options for styling the data that you use to create a layer. The values in the Select a drawing column menu correspond to the column headers in your data. You choose a column to determine which attribute the symbols should represent. In this case, you want to visually compare the revenue of salons in Ottawa.

  17. For Select a drawing column, choose Revenue.

    When you choose the column, the style that is typically most suitable for the data is selected by default and applied to the map. You'll apply a style that symbolizes features with graduated circles, which are useful for comparing records on the map.

    Note:

    For more information about the other styles, see Change a layer's style.

  18. In the list of suggested styles, confirm that the Counts and Amounts (size) style is selected.

    Style by Revenue column using Counts and Amounts (size)

    The Map 1 window shows a map of the Ottawa, Canada, area. The map displays the salon locations styled according to revenue. The graduated circles give you a sense of how salon revenue is distributed in the region.

  19. Click the back arrow to return to the layer list.

    The map layer that contains the salons is named according to the cell range that you chose in the worksheet. You'll provide a more meaningful layer name here.

  20. In the layer list, double-click the $A$1:$H$6 layer to edit the text. Type salons and press Enter.

    Layer settings pane

  21. Close the layer list.
  22. If you don't see five green symbols on the map, resize the map window and drag the map to pan across until you see all the features on the layer. (The rightmost symbol is small, so it may be difficult to see at first.)
    Tip:

    You can also zoom the map using the navigation tools in the corner.

    Map window with Orleans salon circled

    The salon in Orleans (to the northeast) is generating the lowest revenue of the five locations. This is the newest salon—the one for which you may want to send promotional packages to potential new customers.

    The map tools, displayed as a column of expandable icons at the side of the map, contain tools for working with the map and data; you’ll use some of these throughout this lesson. The map tools also include tools that you can use to search for places of interest, select features on the map, and change the basemap.

    The salons layer displays over a basemap, which provides context for your locations. In an ArcGIS organization, the administrator chooses the default basemap, but you can change it for your map. You want to draw attention to the data that you're adding to the map, so you'll choose a simple basemap.

  23. From the map tools, click the Basemap.

    Basemap on the map tools

    The Basemaps pane appears.

  24. Click Dark Gray Canvas.
    Note:

    Your organization may use different basemaps, depending on how your administrator has configured it. If you don't see Dark Gray Canvas, choose another simple basemap that provides enough contrast with the salons layer. If your map already uses this basemap, close the Basemap pane.

    Dark Gray Canvas basemap

    The Dark Gray Canvas basemap is used to minimize background distraction.

    Map of salons with dark gray basemap

  25. Close the Basemaps pane.

    Now that you've located your salons on a map and chosen a neutral basemap, you're ready to add the potential new customers to the map.

Map customer addresses

Next, you'll add a layer to the map that shows the locations of the potential new customers who provided their contact information at the Women's Show. This data is in the recommended format of a Microsoft Excel table.

  1. Click the new customers tab to make it the active worksheet.

    The customer information is contained in an Excel table. When you add a layer to the map from a table, new rows or columns that get added later are automatically included in the map. When you add a layer to the map from a range of cells, as you did in the previous section, adding rows or columns will not update the map.

  2. From the map tools, select Layers. Click the Add from Excel button.

    Add data from Excel.

    Note:

    If you minimized the map window earlier, click the ArcGIS tab, click Go to Map, and choose the map to open it.

  3. In the Add from Excel window, for Dataset, choose customers. For Location type, select Address.

    As before, you'll confirm that the location information is appropriate for your map.

  4. For Country, choose Canada.
  5. If necessary, click Multiple columns and verify that the location fields were mapped correctly to the corresponding columns in your spreadsheet.
  6. Click Add to map.
  7. Click Layer options. Confirm that the customers layer is selected in the Active layer drop-down menu.

    The layer is styled by Location (Single symbol) by default. This styling is helpful for seeing where customers are distributed in the region, and for analyzing customers’ proximity to a salon. However, the worksheet contains additional information that is important to visualize; Ottawa is a bilingual city, so you’ll style the layer by the customers’ preferred language using the Types (Unique symbols) style.

  8. In the Select a drawing column drop-down menu, choose Language. In the list of suggested styles, verify that Types (Unique symbols) is selected.

    Drawing column set to Language.

    In this style, features are drawn with various symbols to represent each value in the drawing column you selected. Now you'll change the default symbol style, as it is similar to the style used for salons.

  9. Hover over the Types (Unique symbols) style and click Style options.

    Style options for Types (Unique symbols)

    The Styling pane updates to show Symbology configuration options.

  10. In the Styling pane, expand the Symbology section.

    The Symbology section applies styling changes to all symbols in the layer. When using the Types (Unique symbols) style, the Symbology section shows basic options to change the shape only, and advanced options to change the outline only. To change the fill of the symbols or to use different symbols for the Types (Unique symbols) style, you must change the symbols for each unique value.

  11. If necessary, in the Styling pane, expand the Unique values section.

    Unique values section in Styling pane

    The section shows how each value is styled and a count of how many features are in each category.

  12. In the Unique values section, click the symbol for French.

    The Edit symbol pane appears.

    Edit symbol pane

  13. In the Symbols drop-down menu, set the symbol category to Shapes and choose the blue circle. Set the symbol size to 15 pixels (px).

    Shape symbol settings

    The symbol on the map changes automatically.

  14. Click OK to close the Edit symbol pane.
  15. In the Styling pane, under the Unique values section, click the symbol for English and repeat the process to set the symbol to the red circle.
  16. Click the Back button to return to the layer list.

    The symbols for the customers layer obscure the symbols for the salons layer, so you'll move the salons layer above the customers layer.

  17. In the layer list, click and drag the salons layer above the customers layer.

    Drag salons layer to top of the list.

    The salons layer moves above the customers layer. On the map, the green salon symbols appear on top of the blue and red customer symbols.

  18. In the layer list, for the customers layer, click the More options button and click Zoom to.

    Zoom to

    The map zooms to the full extent of the selected layer so you can see all its features.

  19. In the Layers pane, for the customers layer, click the Expand button.

    Expand the customers layer to view the legend.

    The layer legend is now visible in the Layers pane. The red circles represent customers who prefer speaking English and the blue circles represent customers who prefer speaking French.

  20. Close the layer list.

    Now you can see the distribution of potential customers who surround each salon location by their language preference.

    Map of potential customers and salon locations

    Your map now shows the locations of the salons and the locations of potential customers. The layer styling clearly identifies the customers’ preferred language for receiving marketing communications. The salon location in Orleans currently has the smallest amount of revenue. This map provides a visual estimate that about half the customers near the Orleans salon prefer speaking French. This can inform any promotional campaigns you might introduce to the area to best meet your customers' needs.

Configure pop-ups

Next, you'll configure pop-ups for the customers layer. Pop-ups appear when you click a feature on the map; they contain descriptive information about the features in each layer on the map. The attribute information that displays in a pop-up comes from the columns and rows in your data.

  1. Click a customer location on the map to open its pop-up.

    Pop-up for customer location

    The basic configuration of a pop-up is just what you see: a list of fields and values associated with a layer. The information should be familiar to you because it comes from the table.

    Tip:

    In this example, the bottom of the pop-up shows "1 of 2." When you open a pop-up, you also access pop-ups for other features at or near the same location. (These may be in the same layer or different layers.) Click the forward and back arrows to see the other pop-ups.

    You can change the way this information is presented in pop-ups on this layer. You'll add a header and specify which attributes to display.

  2. Close the pop-up.
  3. On the map tool, click Layers. At the top of the Layers pane, select Layer options. From the layer options, select Pop-ups.

    Pop-up settings button

  4. In the Pop-ups pane, for Active layer, confirm that the customers layer is selected and that Enable pop-ups is enabled.

    Confirm Active layer and Enable pop-ups configuration.

  5. For Title field, choose Name.

    Now you'll specify which attributes to include in the pop-up. Because you're using the Name field as the pop-up's title, you don't need this information to be repeated in the pop-up. Also, it's unnecessary to show the city and province names, which are the same for each location. The basemap labels tell anyone using the map that this is Ottawa, Ontario.

  6. Uncheck the circles next to Name, City, and Province.

    A field has both a name and an alias. An alias is a display name that replaces the field name in the pop-up. By default, the alias and field names match, but you can change the alias to something more informative or familiar.

  7. Point to the Address row and click the Edit button. Type Home Address and press Enter.

    Pop-up settings pane

  8. On the map, click a customer feature near the Orleans salon to view the updated pop-up.

    The pop-up also contains several tools that allow you to work with the selected feature.

  9. In the pop-up, click the Zoom to button.

    Updated pop-up with Zoom to highlighted in green.

    The map zooms to the selected feature.

    Note:

    To learn more about pop-ups, see Display pop-ups.

  10. Close the pop-up. In the Pop-ups pane, click the Back button to return to the layer list.
  11. On the salons layer, click the More options button and click Zoom to layer.

    The map zooms to the full extent of the selected layer so all its features display in the map window.

  12. In Excel, click Save.

You've created a map that compares salon revenue and shows potential new customers and highlights pertinent information about them. You also configured pop-ups so you can view detailed information about each customer.


Share the results

Now that you have a map that allows you to visually explore customer prospects for your salons, you'll share your map on ArcGIS Online to present your results.

Share a map on ArcGIS Online

Before you create your marketing presentation, you’ll share your map as a web map on customers. Sharing a map on customers is a quick way to share information with others in or outside of your organization. When you share a map, a web map is created in customers. Once you publish the map, you can share a link of the map for others to view your results.

  1. If necessary, open the lesson spreadsheet SalonCustomersOttawaArea.xlsx in Excel and sign in to ArcGIS.
  2. In the map window, on the map toolbar, click Share map.

    Share map button

  3. In the Share map pane, enter the following:
    • For Title, type Orleans Salon Promo, followed by your name or initials.
    • For Tags, type Salon, Orleans, Promo.
    • For Summary, type Promo for potential customers for Orleans salon.

    These fields are used to display information about the map on ArcGIS and are also used for searching.

  4. For Share with, check Everyone (public).

    Share map pane

    Alternatively, you can choose to share only within your organization, or any groups to which you belong.

  5. Click Share.

    Once the map has successfully published, a confirmation message appears at the bottom of the map to indicate that the map has been shared. The Share map pane also updates to confirm the map was successfully published and includes a link to the map.

  6. In the Share map confirmation window, click the link to view your web map.

    Link to view published web map

    Your web map item detail page appears in a browser.

    Web map item details page

  7. Sign in to your ArcGIS Online account and click Open in Map Viewer.
    Note:

    Depending on your ArcGIS Online organization settings, the button to open your web map may say Open in Map Viewer Classic. Opening the web map in either version of Map Viewer will allow you to view your published web map.

  8. In Excel, click Save. Close Excel.

In just a short amount of time, you created a map that shows the location of hundreds of potential customers. The map allows you to visually analyze the potential customers' proximity to your salons and highlights their preferred language for marketing communications. Finally, you created a visually compelling web map to present your analysis using ArcGIS for Office and your ArcGIS organization.

You can find more lessons in the Learn ArcGIS Lesson Gallery.