Article ID: 147637 - View products that this article applies to.
This article was previously published under Q147637
In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data that is associated with geographic regions. This article describes how to create a map on a worksheet in Microsoft Excel.
The process of creating a map using Data Map/Microsoft Map consists of the following steps:
Select the Geographic DataThe first step in generating a map is to select the data that will appear on the map. For Microsoft Map (Data Map in version 7.0) to correctly generate a map, the selected data must be arranged in columns, where one column contains geographic data, such as country names, states, or postal codes.
In this example, enter the following data in cells A1:B4
and select cells A1:B4.
A1: Country B1: Total Sales A2: Denmark B2: $17,459 A3: France B3: $11,814 A4: Italy B4: $18,449
NOTE: If you use postal codes as your geographic data, you must format them with the Zip Code number format before you create your map.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/131929/EN-US/ )XL: Zip Codes in Data Map Must Be Formatted with Zip Code Style
Create the MapAfter you select the data, follow these steps:
Customize the MapAfter you insert the map, you can use the Microsoft Map Control dialog box (Microsoft Data Map Control in version 7.0) to modify what data appears on the map and how the data is represented.
All six formats that Data Map can use for presenting your data are represented as icons at the lower-left side of the Microsoft Map Control dialog box (Microsoft Data Map Control in version 7.0). The following table lists the six formats and how they represent data:
To select the data formats and their associated data, follow these steps:
Format Data presentation -------------------------------------------------------------------- Value Shading Depth of color represents rank. Dot Density A dot represents data, where each dot is some known quantity. Pie Chart A small pie chart represents data for each geographic area. Category Shading A different color represents data belonging to a different category. Graduated Symbol A symbol represents data, where the size of the symbol indicates data size. Column Chart A small column chart represents data for each geographic area.
For more information about Data Map, click Contents and Index on the Help menu, click the Index tab in Excel Help, type the following text
data mapand then double-click the selected text to go to the "Microsoft Data Map" topic. If you are unable to find the information you need, ask the Office Assistant.
Data Map also contains online Help for you to use. To use Data Map Help, click Data Map Help Topics on the Help menu while Data Map is open.