XL2000: Graduated Symbol Is the Only Symbol Available in Microsoft Map (214387)
The information in this article applies to:
This article was previously published under Q214387 SYMPTOMS
When you create a Microsoft Map object in Microsoft Excel, the only symbol that is available in the Microsoft Map Control dialog box is the Graduated symbol (five-pointed star).
CAUSE
This problem occurs when the data that you use to create the map uses ZIP/Postal Codes as geographic data.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
If you format the first column of the data with a postal code number format and then create a Microsoft Map object on the worksheet, the only symbol that you can display on the map to represent the data is the Graduated symbol.
REFERENCESFor additional information about how to create a map, click the article number below
to view the article in the Microsoft Knowledge Base:
147637 XL: How to Create a Map with Microsoft Data Map
For more information about how to create a map, click Microsoft Map Help on the Help menu, type creating a map in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 11/5/2003 |
---|
Keywords: | kbbug kbpending KB214387 |
---|
|