How to Add New Data to a Data Map Chart

Article translations Article translations
Article ID: 147737 - View products that this article applies to.
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
Expand all | Collapse all

Summary

In Microsoft Excel, you can add additional columns of data or new rows of data to an existing data map. However, when you insert the new 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 and states, in the first column of the worksheet, and then arrange the rest of the information in columns on the worksheet. You are unable to add data to a 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 to avoid selecting data already shown on the map, the "You must include a column of geographical data in your selection" message is displayed. Adding data columns to a previously prepared Data Map puts duplicate column label buttons in the Data Map Control box. Extra labels cannot be removed. To avoid this problem, delete the previously created Data Map and redraw the Data 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

Properties

Article ID: 147737 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbualink97 KB147737

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com