How to Add New Data to a Data Map Chart

This article was previously published under Q147737
This article has been archived. It is offered "as is" and will no longer be updated.
This article also applies to:
  • Microsoft Excel for Windows 95 7.0
In Microsoft Excel, you can add additional columns of data or newrows of data to an existing data map. However, when you insert thenew data, you need to include the matching column of geographic names.
More information
Geographical labels must be in the first column (and not in the first row).Therefore, list the geographic areas, such as names of countries andstates, in the first column of the worksheet, and then arrange the rest ofthe information in columns on the worksheet. You are unable to add data toa Data Map using drag-and-drop functionality.

To add new columns or rows of data to a data map, do the following:

  1. Double-click the map to make it active.
  2. On the Insert menu, click Data.

    The Data Map dialog box appears.
  3. On the worksheet, highlight to select the range of cells you want to include on the map. Include the column of geographic labels and row of column labels, all rows and columns of data used previously, and the new data columns and rows.

    NOTE: If you do not select the geographic label column (even though you used it to create the original map), you receive the error: "You must include a column of geographical data in your selection."
  4. On the View menu, click Data Map Control.
  5. For Microsoft Excel Data Map to include the new rows of data on the map, select the new column label buttons created in the Data Map Control dialog box and replace the original labels with new ones. (Previous labels use only the original rows of geographical data.)
  6. For Microsoft Excel Data Map to include the new columns of data on the map, select the new column label buttons in the Data Map Control dialog box, and drag them to the box below to replace a previous label.
NOTE: If you use the CTRL key to highlight discontiguous columns of data toavoid selecting data already shown on the map, the "You must include acolumn of geographical data in your selection" message is displayed. Addingdata columns to a previously prepared Data Map puts duplicate column labelbuttons in the Data Map Control box. Extra labels cannot be removed. Toavoid this problem, delete the previously created Data Map and redraw theData Map as desired.

For more information about working with rows and columns in Data Map,please see the following article in the Microsoft Knowledge Base:

131731 XL: Data Map Charts Use Hidden Rows and Columns
XL 97

Article ID: 147737 - Last Review: 10/26/2013 13:29:00 - Revision: 2.0

Microsoft Excel 97 Standard Edition

  • kbnosurvey kbarchive kbualink97 KB147737