Copyright: ©1995 MapInfo Corp., Troy, NY, all rights reserved


Change the default option for refreshing data

1	On the Tools menu, click Options.

2	Click Use As Default For New Maps.

3	Click Manual to require that data be manually refreshed whenever the data on the map changes.

Click Auto to automatically refresh data whenever the data on the map changes.

4	Click OK.


Refresh data

If you change the data used on your map, the map may need to be updated, if the default option for refreshing data on the Microsoft Map Options dialog box is set to Manual.

•	To update the map, on the Map menu, click Refresh, or click Map Refresh  [image].


Set up your maps to use with Microsoft Map

Use the Data Installer to set up maps for use with the Microsoft Map component of Microsoft Excel and Microsoft Office.

Microsoft Excel includes an assortment of sample maps, but many other maps are also available. If you purchase additional maps, or if you create your own maps using MapInfo for Windows, use the Data Installer to prepare your maps for use with Microsoft Map. For information about purchasing additional maps, click  [image].

To run the Data Installer, double-click DATAINST.EXE.

Note   Microsoft Map does not support any MapInfo map that is based on a raster image (such as an aerial photograph). Also, Microsoft Map does not support any MapInfo street map that is actually a relational join of two separate tables.


Add more data

1	To add a column of data from Microsoft Excel, click Data on the Insert menu.

To insert a column from another application, click External Data on the Insert menu. For example, if you want to insert data from a Microsoft Access database, click External Data.

2	Select that column along with the column containing the geographic regions you originally used to create your map. The new data column must be contiguous with the geographic region column.

To add a new row of data to the map, insert the row between existing rows. Then use Map Refresh  [image]  to update your map with the new data.


Add pie charts or column charts to a map

A map can contain pie charts or column charts, but not both.

1	If the Microsoft Map Control dialog box is not displayed, click Show/Hide Microsoft Map Control  [image].

2	Drag Pie Chart  [image]  or Column Chart  [image]  into the box in the lower-right corner of the Microsoft Map Control dialog box.

3	Drag a column heading button from the top of the dialog box onto the chart button.

4	Drag additional column heading buttons onto the chart button until your map includes all the columns you want. You can use up to eight column names.


Add a custom pin map

1	On the Map menu, click Open Custom Pin Map.

2	To create a new pin map, type a name for the pin map.

To open an existing pin map, click a name in the list.

3	Click OK.

4	Click Custom Pin Map  [image].

5	Click the map.

6	Type a description.

7	When you finish typing, press ENTER.

Tip   If you do not want the text to be located to the right of the symbol, drag the text where you want it. After you move the text, it remains linked to the symbol. If you move the symbol, the text moves with it.


Change the symbol style in a custom pin map

•	To change the symbol style, right-click the symbol, and then click Format on the shortcut menu.


Add text

1	Click Add Text  [image].

2	Click the map where you want to add the text.

3	Type the text.

4	When you finish typing, press ENTER.

Tip   If you plan to zoom in on part of the map, zoom in before you add text. Otherwise, the text will be enlarged when you zoom in.


Change the font name, size, bold/italic properties, and color

•	To change the style of the text, click the text with the right mouse button, and then click Format Font on the shortcut menu.


Change the default colors for map features

1	On the Map menu, click Features.

2	Click a feature in the list.

3	Click Custom.

4	If you selected road or boundary features, select a color in the color box under Custom.

If you selected symbol features, click Symbol under Custom to change the symbol style.


Change colors, symbols, functions, and sizing options for map formats

1	If the Microsoft Map Control dialog box is not displayed, click Show/Hide Microsoft Map Control  [image].

2	In the work area at the bottom of the Microsoft Map Control dialog box, double-click a format button.

3	Select the display options you want to change.


Change the data column used on a map

If you selected several columns of data when you created the map, you can switch the column of data that appears on the map.

1	If the Microsoft Map Control dialog box is not displayed, click Show/Hide Microsoft Map Control  [image].

2	Drag a column heading button onto the format button you want to change at the bottom of the Microsoft Map Control dialog box.

If you want to use data that was not part of your original selection, you can add a new data selection.

How?

Tips

•	Most map formats require numeric data. If a column contains text instead of numbers, you can drop that column heading button only onto a category shading format button.

•	At the top of the Microsoft Map Control dialog box, you can double-click a column heading button to see its data source (such as the worksheet name and cell range).

•	Sometimes the column heading buttons are too narrow to show the entire column heading. You can resize the Microsoft Map Control dialog box to change the button size.


Change the type of formatting

1	If the Microsoft Map Control dialog box is not displayed, click Show/Hide Microsoft Map Control  [image].

2	Drag a format button from the left side of the dialog box into the work area at the right.

Tips

•	Dragging the button onto an empty space in the work area adds new formatting. Dragging the button on top of an existing button replaces the existing formatting.

•	There are some restrictions on converting one map format to another. For example, you can convert pie charts to column charts, but you cannot convert pie charts to graduated symbols. This is because a pie chart format uses multiple columns of data, and a graduated symbols format uses only one column.


Change the style of a custom label

You can assign a different style to each custom label in your pin map. For example, if you want to show store locations, you could use green squares to represent your stores and blue circles to represent your competitors' stores.

1	Click Select Objects  [image].

2	Double-click a symbol.

3	Select a new symbol in the Symbol dialog box.

4	To change the color, size, or font of the symbol, click Font.


Change the style of titles and text

1	Click the text with the right mouse button.

2	On the shortcut menu, click Format Font.

3	Select the options you want.


Change the map's title

1	Double-click the title.

2	Type your changes.

3	When you finish typing, press ENTER.


Copy a map to another application

1	Click outside of the map.

2	Click the map once to select it.

3	On the Edit menu, click Copy.

4	Switch to the other application.

5	On the Edit menu, click Paste.

Note   If the application has a Paste Special command, click Paste Special to create a link with the original document, so that changes made to the original map will appear in the pasted copy.


Create a map

1	Select a cell range in Microsoft Excel. One column in the cell range must contain geographic data (such as country names).

2	On the Insert menu, click Map.

3	Drag to specify where the map will go.

4	If the data you selected is ambiguous, or if there are misspellings in your data, a dialog box will ask you how to proceed.


Change the legend

What do you want to do?

Change the size of text in the legend

Edit the legend text

Remove or restore legends and titles

Shrink or expand the legend


Change the size of text in the legend

1	Click the legend to select it.

2	Drag a corner of the legend box to resize it. The text resizes to fit the legend box.


Change the size of titles and text

1	Click Select Objects  [image].

2	Click the text to select it.

3	Drag a corner of the text box to resize it. The text resizes to fit the box.


Edit the legend text

You can replace the legend’s numeric range descriptions with other text, such as "High, Medium, Low."

1	Double-click the legend.

2	In the Edit Legend dialog box, type a new title or subtitle.

3	Click Edit Legend Entries.

4	Type new range descriptions.


Shrink or expand the legend

1	Double-click the legend.

2	To shrink the legend to one line of text, select the Use Compact Format check box.

To expand the legend, clear the Use Compact Format check box.


Remove or restore legends and titles

1	Right-click the legend or title.

2	On the shortcut menu, click Hide.

Tips

•	To restore all hidden map legends, click All Legends on the View menu.

•	To restore a hidden title, click Title on the View menu.


Delete a map

1	Click outside of the map.

2	Click the map to select it. Do not double-click.

3	Press DELETE.


Remove map features

1	On the Map menu, click Features.

2	Clear the check boxes for the features you want to hide.

Tip   When you hide map features, you can still see the color-coding for those features. In this way,  you can create maps that show only color-coding, without showing unshaded areas.


Remove color-coding, pie charts, or other formatting

•	To delete pie charts, color-coding, or other formatting from the map, drag the format button off the Microsoft Map Control dialog box.


Change the view or placement of a map

What do you want to do?

 	Zoom in or out on a map

 	Pan across a map

 	Move or size an embedded map on a worksheet

 	Cancel the last view change


Zoom in or out on a map

•	To increase the magnification of an area of the map, select a zoom percentage greater than the one currently displayed in the Zoom box on the Microsoft Map toolbar.

•	To reduce the magnification of an area of the map, select a zoom percentage lesser than the one currently displayed in the Zoom box on the Microsoft Map toolbar.

•	To view the entire map, click Entire Map on the View menu.


Pan across a map

Panning moves the map within its frame, without zooming in or out on the details of the map.

•	To move the map within its frame, click Grabber  [image] and then drag the map.


Move or size an embedded map on a worksheet

•	To move the entire map to a different place on your worksheet, point to the outer edge of the map and drag.

•	To resize the map, drag the handles at the corners of the map.


Cancel the last view change

•	To cancel the last change you made to the view of the map, click Previous on the View menu.


Open a MapInfo map

If you have used the MapInfo mapping software to create maps, you can use those maps with Microsoft Excel. You must set up each MapInfo map you want to use.

•	To set up a map, run the Data Installer (Datainst.exe).


Guidelines for setting up data to create a map

Arrange the information in columns on a worksheet. One column must contain geographic data, such as names of countries or states.

If your worksheet contains additional data for each map feature (such as sales figures for each country), include that data in the selection.

If there are headings at the top of your columns, include those headings in the selection.

Tips

•	To see a list of standard spellings and abbreviations for map features, see the sample workbook Mapstats.xls in the Data folder under the folder where you installed Microsoft Map.

•	If your data contains numeric postal codes, such as U.S. ZIP Codes, make sure the postal codes are formatted as text, not as numbers. Formatting postal codes as text prevents zeros from being removed.


Column chart format

A map format that displays a small column chart over each area of the map. Each column chart shows data for that area.


Change the data and formats displayed on the map

You can change the appearance of your map by dragging and double-clicking the buttons on the Microsoft Map Control dialog box.

What do you want to do?

 	Add pie charts or column charts to the map

 	Change colors, symbols, functions, and sizing options for map formats

 	Change the type of formatting

 	Change the data column used on a map

 	Display the Microsoft Map Control dialog box


Display the Microsoft Map Control dialog box

•	To display the Microsoft Map Control dialog box, click Show/Hide Microsoft Map Control  [image].


Dot density format

A map format that shows data as small dots. Each dot represents some quantity; for example, each dot might represent 1,000 people.


legend

A box that describes how colors and styles on the map represent data values.

The numbers in parentheses show how many map regions are assigned to each range. The legend entry "17 to 34 (3)" indicates that there are three map regions assigned to the white range. A map region is assigned to the white range if it has a value greater than or equal to 17, but less than 34.

To remove the legend, select it and press DELETE. To display the legend, click All Legends on the View menu.


Pie chart format

A map format that displays a small pie chart over each area of the map. Each pie chart shows data for that area.


Graduated symbols format

A map format that shows data as symbols drawn at various sizes. Larger symbols represent larger data values.


Category shading format

A map format that uses various colors to show how map regions belong to different categories. For example, on a map of sales territories, map regions that belong to the "Northeast" territory could appear in red, and regions that belong to the "Southwest" territory could appear in green.


Value shading format

A map format that shows map features in different shades of a color to show numeric values. For example, map regions with large data values could appear in deep red, and regions with smaller values could appear in pale red.


custom label

A marker that represents a point of interest on the map. You create custom labels by clicking Custom Pin Map  [image]. You can add optional descriptive text to a custom label.


Examples of map formats

Which example do you want to see?

 	Category shading

 	Value shading

 	Dot density

 	Graduated symbols

 	Column chart

 	Pie chart


About computer mapping

Computer mapping helps you to visualize and analyze your data.

When you view large amounts of data in row-and-column form, you may find it difficult to understand the full meaning of the data. But when you view your data as a color-coded map, you can easily see the trends and relationships in the data.

Once you have displayed your data on a map, the map helps you geographically analyze the data. For example, you can use maps together with demographic data to analyze market potential or to plan sales and marketing efforts.

•	To view an electronic brochure, click  [image].

•	Visit MapInfo on the World Wide Web. If you are running Windows 95 and have set up your computer to connect to the Internet, click here to go to MapInfo on the WWW.

•	To order additional maps and data, click  [image].


Map and data library

Microsoft Excel comes with an assortment of sample maps, plus demographic data for each map. Demographic data, such as population statistics, is provided in the workbook Mapstats.xls.

For information about purchasing additional maps and demographic data, click  [image].


How to obtain more maps

Many additional maps and demographic data files are available. For information, do any of the following:

•	To view an electronic brochure, click  [image].

•	Visit MapInfo on the World Wide Web. If you are running Windows 95 and have set up your computer to connect to the Internet, click here to go to MapInfo on the WWW.

•	Contact MapInfo Corporation:

MapInfo Corporation
One Global View
Troy, NY  12180-8399  USA

Telephone:	800.488.3552 (USA only)
	518.285.7110 (International)
Fax:	518.285.7440
Internet:	datamap@mapinfo.com


Troubleshoot mapping problems

What do you need help with?

 	My map doesn't show enough detail.

 	I don't want a box around the map title.

 	Parts of my map are not color-coded correctly.

 	When I zoom in on my map, the text size changes.

 	This map doesn't show the right geographic features.

 	There is an empty space where my map used to be.

 	I'm having trouble querying Microsoft Access data.

 	My pin map labels don't look correct.


Parts of my map are not color-coded correctly.

If some areas of your color-coded map appear in the wrong color, it may mean that there is no data for those map areas.

For example, if one area appears in green, the green area has no data. Green is the map feature's default color.

•	Make sure that the cell range you selected contains all the data you want to show. You will only see color-coding for a map region when your cell range contains at least one row of data for that region.

•	If you do not have any data for a map region, that region will not be color-coded. However, you can change the map's default color.

How?


My map doesn't show enough detail.

•	On the Map menu, click Features to add more features to the map.

•	To get a closer look at a particular map area, select a higher zoom percentage in the Zoom box on the Microsoft Map toolbar.

•	To place markers at points of interest, click Custom Pin Map  [image].

•	Expand your map library by installing additional maps. For example, if you want to see county boundaries, you need to purchase additional maps. For more information, click  [image].


When I zoom in on my map, the text size changes.

•	Zoom in on your map first, and then create text.

•	Use the map title and subtitle if you need to create text that stays the same size, even when you zoom in. On the View menu, click Title or Subtitle.


This map doesn't show the right geographic features.

•	On the Map menu, click Add Feature to add more features to the map.

•	Select different data when you create the map.

Tip   Your map automatically shows features that match the names in your data. If you select a column of country names, the map will show countries. To see a more detailed map, select data that includes the names of smaller areas.

•	Expand your map library by purchasing additional maps. For more information, click  [image].


I don't want a box around the map title.

The map title and subtitle always appear within a box, so that they are always visible, even if you move the title over a dark section of the map.

If you don't want a box around the map title, you can use text as a title.

1	Click the title with the right mouse button.

2	On the shortcut menu, click Hide.

3	Click Add Text  [image].

4	Click the map.

5	Type text to use as a map title.


I'm having trouble querying Microsoft Access data.

Your map can include data from any Microsoft Access table or query. To add Microsoft Access data to your map, click External Data on the Insert menu.

Some Microsoft Access queries have parameters. When you run a parameter query, dialog boxes prompt you to type values.

If a parameter query dialog box appears, you must type appropriate values. Typing inappropriate characters can cause the query to fail. For example, if a dialog box prompts you for numeric values, do not type letters.

Tip   You can set up the query so that it will warn you if you type invalid characters. To change how the query is set up, run Microsoft Access. For more information about customizing the query parameters, see the Microsoft Access documentation.


There is an empty space where my map used to be.

If you see an empty space, it may mean that you accidentally zoomed in on a blank part of the map. Switch to a view of the entire map, and then zoom in again on the part you want.

•	To view the entire map, on the View menu, click Entire Map.


My pin map labels don't look correct.

If the custom labels in your pin map appear to have incorrect sizes or positions, the pin map was probably created for use with a different map.

For example, suppose you create a pin map that contains custom labels across North America. If you add that pin map to a map of the world, the pin map labels may appear to have moved slightly (because the labels were designed for a North American map, not a world map).


custom pin map

A set of custom labels showing points of interest on a map. A pin map is like a set of pushpins that you use to mark special locations, such as regional sales offices.


Microsoft Map Control dialog box

A dialog box that you use to create or customize the color-coding, pie charts, or other types of formatting on your map.


Add labels to a map

1	Click Map Labels  [image].

2	In the Map Feature To Label box, select a feature name.

3	To use the names of map features as labels, click Map Feature Names.

To use the numeric values calculated for each area as labels, click Values From.

4	Click OK.

5	Move the mouse pointer over the map. When you point to a map feature that can be labeled, a label preview is displayed.

6	To add the label to the map, click.

Tip   To change the label's font style, click the label with the right mouse button, and then click Format Font on the shortcut menu.


Remove a pin map

•	On the Map menu, click Close Custom Pin Map.


Unable to connect

Could not automatically establish a connection to the MapInfo Web site.

Once you have manually established a connection to the World Wide Web, visit the MapInfo Web site at http://www.mapinfo.com


Select Objects

Selects legends, titles, labels, or text for moving, sizing, or deleting.


Labeler (Tools menu)

Adds labels (names of map features) to the map.


Grabber

Moves the map within the window.


Text

Adds text to the map.


Custom Pin Map

Adds custom labels to the map.


Microsoft Map Control (View menu)

Shows or hides the Microsoft Map Control dialog box. This button is available only if you selected data to map.


Redraw Map (View menu)

Redraws the map. Every flat map shows a stretched view of the earth, whether the map is on paper or on a computer. If you used the Grabber button  [image]  to move the map, click Redraw Map to minimize the stretching.


Entire Map (View menu)

Centers the map and zooms out so that all features in the map are visible.


Center Map

Specifies the center of the map.


Zoom box

Changes the zoom magnification of the map.


Refresh (Map menu)

Updates the map to reflect the current data from your worksheet. If you change the data used in your map, the Map Refresh button on the Microsoft Map toolbar becomes active to indicate that the map may need to be updated. To update the map, click Refresh on the Map menu when Microsoft Map is active, or click Map Refresh  [image].


Shows the title of the map.


Shows the subtitle of the map.


Shows the legend of the map.


Shows your data displayed in a map.


Displays the Font dialog box, where you can choose the font type and style for the title.


Displays the legend in a compact style. To display the full legend, clear the check box.


Displays the Font dialog box, where you can choose the font type and style for the subtitle.


Displays the Font dialog box, where you can choose the font type and style for the compact title.


Enter a title for the legend. This feature is enabled when the Use Compact Format check box is cleared.


Enter a subtitle for the legend. This feature is enabled when the Use Compact Format check box is cleared.


Enter a title for the compact form of the legend.


Applies currency formatting to the numbers in the map legend.


Displays the legend. To hide the legend, clear the check box.


Customizes the legend entries.


Restores the default settings for the legend.


# HIDC_PARAM_INPUTEnter a parameter value.


Type the name of the folder that contains the data files for Microsoft Map.


Type a list of other folders where the data files reside.


Displays the Font dialog box, where you can change the font type and style.


Shows the current symbol.


Shows the current font.


Select a legend entry to edit.


Type your changes for the selected legend entry. This does not affect any calculations; it changes only the appearance of the legend.


Changes the font of the legend.


Select an automatic or custom fill.


Select the Visible check box to display this feature in a map. To hide a map feature, clear the check box.


Displays map features.


Displays the selected map feature in its default style. The Automatic button is not available if the selected feature's Visible check box is cleared.


Click to select a new color for the selected map feature. The Custom button is not available if the feature's Visible check box is cleared.


Select a new color for the selected map feature.


Click to select a new custom symbol for the selected map feature.


Adds more features to the map.


Removes the selected feature from the map.


Closes this dialog box and saves any changes you made.


Closes this dialog box without saving any changes you made.


Changes the color of columns. Click the data column in the Columns box, and then click a color in the Color box.


Changes the color of columns. Click the data column in the Columns box, and then click a color in the Color box.


Changes the color of columns. Click the data column in the Columns box, and then click a color in the Color box.


Applies different height scales to the columns in each column chart. For example, if the first bar in each chart represents a large number (such as population), and the second bar in each chart represents a small number (such as average age), select the Independent Scale check box.


Applies different height scales to the columns in each column chart. For example, if the first bar in each chart represents a large number (such as population), and the second bar in each chart represents a small number (such as average age), select the Independent Scale check box.


Click SUM to base the column charts on the sum of values for each map region. Click AVERAGE to base the column charts on the average value for each map region.


Click SUM to base the color coding on the sum of values for each map region. Click AVERAGE to base the color coding on the average value for each map region.


Click SUM to base the color coding on the sum of values for each map region. Click AVERAGE to base the color coding on the average value for each map region.


Shows the column charts. To hide the column charts, clear the check box.


Removes the format from the map.


Enter the dimensions of the column charts.


Changes the height of the column charts. Type a number in the Height box.


Type a data value in the At Value box. The At Value box is not available if the Independent Scale check box is selected.


Enter a number to change the width of the column charts.


Type a smaller number to increase the number of dots in the map. Type a larger number to decrease the number of dots.


Specifies the size of the dots in the map.


Specifies the size of the dots in the map.


Specifies the size of the dots in the map.


Shows the dot density formatting. To hide the formatting, clear the check box.


Deletes the dots.


Sets up the map so that symbols appear in various sizes. To set up the map so that all symbols are the same size, clear the Graduated check box.


Sets up the map so that symbols appear in various sizes. To set up the map so that all symbols are the same size, clear the Graduated check box.


Shows the graduated symbols. To hide the graduated symbols, clear the check box.


Enter a number to specify the symbol sizes. Larger data values appear as larger symbols. When a row of data has the same value as the At Value number, that row's symbol will be as large as the symbol you selected.


Changes the symbol used for mapping.


Previews the symbol.


Displays the Symbol dialog box, where you can change the symbol and font.


Changes the color associated with a data value. Click a value in the Categories box, and then click a color in the Color box.


Changes the color associated with a data value. Click a value in the Categories box, and then click a color in the Color box.


Changes the color associated with a data value. Click a value in the Categories box, and then click a color in the Color box.


Shows the color coding. To hide the color coding, clear the check box.


Changes the color of slices in the pie charts. Click a column in the Columns box, and then click a color in the Color box.


Changes the color of slices in the pie charts. Click a column in the Columns box, and then click a color in the Color box.


Makes the pie charts' sizes proportional to their values. Larger values produce larger pie charts. To make all pie charts the same size, clear the Graduated check box.


Makes the pie charts' sizes proportional to their values. Larger values produce larger pie charts. To make all pie charts the same size, clear the Graduated check box.


Shows the pie charts. To hide the pie charts, clear the check box.


Specifies the size of the pie charts. Type a number in the Diameter box, and then type a data value in the At Value box. When the sum of the values in a pie chart equals the number you type in the At Value box, that pie chart has the diameter you specify. Pie charts representing larger sums have larger diameters.

The At Value box is not available if the Graduated check box is cleared.


Specifies the size of the pie charts. Type a number in the Diameter box, and then type a data value in the At Value box. When the sum of the values in a pie chart equals the number you type in the At Value box, that pie chart has the diameter you specify. Pie charts representing larger sums have larger diameters.

The At Value box is not available if the Graduated check box is cleared.


Specifies the size of the pie charts. Type a number in the Diameter box, and then type a data value in the At Value box. When the sum of the values in a pie chart equals the number you type in the At Value box, that pie chart has the diameter you specify. Pie charts representing larger sums have larger diameters.

The At Value box is not available if the Graduated check box is cleared.


Sets the number of value ranges. For example, if you want to see a map that shows high, medium, and low rankings, set the number of value ranges to 3.


Changes the color scheme of your map. Your map will appear in various shades of the selected color. Darker shades represent larger data values.


Specifies how data values are split into segments.


Creates formatting that shows the same number of map areas in each value range. (In other words, there will be as many map areas in the High value range as in the Low value range.)


Creates formatting that shows value ranges of equal size (such as 0-9, 10-19, 20-29). The value ranges are based solely on the minimum and maximum values in your data.


Shows the color coding. To hide the color coding, clear the check box.


Creates or opens a custom pin map. To create a new pin map, click the upper button, and then type a description in the upper box. To open an existing pin map, click the lower button, and then click a pin map name in the lower box.


Creates or opens a custom pin map. To create a new pin map, click the upper button, and then type a description in the upper box. To open an existing pin map, click the lower button, and then click a pin map name in the lower box.


Creates or opens a custom pin map. To create a new pin map, click the upper button, and then type a description in the upper box. To open an existing pin map, click the lower button, and then click a pin map name in the lower box.


Creates or opens a custom pin map. To create a new pin map, click the upper button, and then type a description in the upper box. To open an existing pin map, click the lower button, and then click a pin map name in the lower box.


Creates or opens a custom pin map. To create a new pin map, click the upper button, and then type a description in the upper box. To open an existing pin map, click the lower button, and then click a pin map name in the lower box.


Resolve misspellings or ambiguities.


Resolve misspellings or ambiguities.


Enter correctly spelled data. If you selected geographic names that are not unique, you will see two Change To boxes. For example, if you selected US County names, you can type state names in the second Change To box.


Click a suggested spelling to replace the misspelled data. The Suggestions box is not available when there are two Change To boxes.


Accepts the correction in the Change To box. If your spelling is correct, the misspelled text from your worksheet or database is replaced with the text in the Change To box. If the spelling is still not correct, you get a message, and this dialog box is redisplayed.


Excludes this row of data from the map.


Excludes every row of data that contains a misspelling.


Click the name of the selection you want in the list.


# IDM_select_a_key_1


# IDM_select_a_key_2


Select a column that does not appear in the list, although it was part of your original selection. Microsoft Map then checks each column you selected to see whether that column contains geographic data.


Resolves ambiguous names in your data. For example, "Paris" could mean Paris, France, or Paris, Texas. Type a name that makes your ambiguous data more specific.


Ignores all rows of ambiguous data. If you click Ignore, some of your data will be left out of the calculations that control the map’s color coding.


Select a column containing additional information that resolves the ambiguous names in your data. For example, "Paris" could mean Paris, France, or Paris, Texas.


Creates a map that includes data.


Click the Microsoft Access table or query that contains the data you want to use.


Lists available fields in the table.


Selects a field for mapping.


Includes all available fields.


Removes a field that you have selected. Click its name in the Fields To Display In Map box, and then click <.


Click to remove all field names from the Fields To Display In Map box.


Selects the fields in the table you want to display in the map.


Saves information about the current list of map features.


Saves information about the current view of the map.


Saves information about the current list of map features or the current view of the map.


Type a description to create a new map template. To replace an existing template with the current settings, click the template name in the box.


Click Save to save the map template. The map settings you specify are saved in a template that you can reuse the next time you create a map. Map formats, such as pie charts and color coding, are not saved in a template, because formats depend on the data you select when you create a map.


Performs a quick analysis of your data. If your data is fixed-width, Microsoft Map will try to match your data only to geographic names that are also fixed-width, such as postal codes.


Performs a thorough analysis of your data. Microsoft Map will test your data against every map in your map library, including maps with geographic names that are not fixed-width. Thorough matching takes longer. However, you might want to select Thorough if the Unable To Create Map dialog box appears when you create a map.


Specifies the matching method and time limit of analysis used by Microsoft Map.


Automatically corrects matches found with one unique instance. Clear the check box to be able to confirm each of these matches.


Specifies the time limit of the analysis.


Changes the units of measurement displayed in dialog boxes to inches, centimeters, or millimeters.


Changes the units of measurement displayed in dialog boxes to inches, centimeters, or millimeters.


Changes the units of measurement displayed in dialog boxes to inches, centimeters, or millimeters.


Changes the units of measurement displayed in dialog boxes to inches, centimeters, or millimeters.


Specifies that new legends use the compact (one-line) format. To set up Microsoft Map so that new legends show full details, clear the check box.


Determines whether the specified Data Refresh option is to be the default. Select the check box to change the default for refreshing data to the specified Data Refresh option.


Click Manual to require that the map be manually refreshed whenever the data on the worksheet changes.


Click Auto to refresh the map automatically whenever the data on the worksheet changes.


Specifies the refresh method.


Click a feature name in the list to select the map feature to label.


Creates labels that show the names of map features.


Creates labels that show the names of map features or numeric data for each map region.


Creates labels that show numeric data for each map region. This option is available only if you have selected data to map and if the data you selected corresponds to the feature in the Map Feature To Label box.


Creates labels that show numeric data for each map region. This option is available only if you have selected data to map and if the data you selected corresponds to the feature in the Map Feature To Label box.


Toolbar command (View menu)
Toolbar (View menu)

Shows or hides the Microsoft Map toolbar.


Title command (View menu)
Title (View menu)

Shows or hides the map title.


Subtitle command (View menu)
Subtitle (View menu)

Shows or hides the map subtitle.


All Legends command (View menu)
All Legends (View menu)

Shows all of the map legends. This command is available only if the map contains at least one format.


Previous command (View menu)
Previous (View menu)

Restores the map to its previous magnification and center position. This command is available only after you change your view of the map — for example, by using the Zoom box or Grabber button.


Data command (Insert menu)
Data (Insert menu)

Links the map to another set of data. After you select the additional data, column heading buttons appear at the top of the Microsoft Map Control dialog box.


External Data command (Insert menu)
External Data (Insert menu)

Links the map to data from another program. After you select the additional data, column heading buttons appear at the top of the Microsoft Map Control dialog box.


Options command (Tools menu)
Options (Tools menu)

Changes the units of measurement and the matching method used by Microsoft Map.


Features command (Map menu)
Features (Map menu)

Shows, hides, and controls the display styles of map features.


Add Feature command (Map menu)
Add Feature (Map menu)

Adds map features, such as roads, cities, or boundaries, to the map.


Open Custom Pin Map command (Map menu)
Open Custom Pin Map (Map menu)

Adds a pin map to the map. To add custom labels to a pin map, use the Custom Pin Map button.


Close Custom Pin Map command (Map menu)
Close Custom Pin Map (Map menu)

Removes the pin map from the map. This command is available only after you have added a pin map to the map.


Save Map Template command (Map menu)
Save Map Template (Map menu)

Creates a map template based on the current map.


Refresh command (Map menu)
Map Refresh button / Refresh (Map menu)

Updates the map to reflect the current data from your worksheet.

If you change the worksheet data used in your map, the Map Refresh button becomes active on the Map toolbar, indicating that the map may need to be updated. To update the map, click Refresh on the Map menu, or click the Map Refresh button.


Column Chart Options command (Map menu)
Column Chart Options (Map menu)

Customizes the appearance of a column chart format.


Pie Chart Options command (Map menu)
Pie Chart Options (Map menu)

Customizes the appearance of a pie chart format.


Graduated Symbol Options command (Map menu)
Graduated Symbol Options (Map menu)

Customizes the appearance of a graduated symbol format.


Category Shading Options command (Map menu)
Category Shading Options (Map menu)

Customizes the appearance of a category shading format.


Value Shading Options command (Map menu)
Value Shading Options (Map menu)

Customizes the appearance of a value shading format.


Dot Density Options command (Map menu)
Dot Density Options (Map menu)

Customizes the appearance of a dot density format.


Delete Custom Pin Map command (Map menu)
Delete Custom Pin Map (Map menu)

Deletes a custom pin map that you created. This command is available only if you have created at least one custom pin map.


Delete Map Template command (Map menu)
Delete Map Template (Map menu)

Deletes a map template.


Click the name of the pin map you want to delete.


Click the map template you want to delete.


Enter your password.


Enter the new text.


Displays a specific error message regarding your data error.


Click Continue to ignore this error or Stop to stop the current mapping process.


Click OK to open a layer, OKTOALL to open all layers, or Cancel to cancel this operation.


Cut command (Edit menu)
Cut (Edit menu)

Removes the selected custom label or text from the map and places it on the Clipboard.


Delete command (Edit menu)
Delete (Edit menu)

Deletes the selected custom label or text from the map, without affecting the Clipboard.


Copy command (Edit menu)
Copy (Edit menu)

Copies the selected text or custom label to the Clipboard. Copies the entire map to the Clipboard if no map elements are selected.


Paste command (Edit menu)
Paste (Edit menu)

Copies text or a custom label from the Clipboard to the map.


Microsoft Map Help Topics command (Help menu)
Microsoft Map Help Topics (Help menu)

Displays the contents of Microsoft Map Help.


About Microsoft Map command (Help menu)
About Microsoft Map (Help menu)

Displays the Microsoft Map version number.