Microsoft KB Archive/167718

= XL: Graduated Symbol Is the Only Symbol Available in Data Map =

Article ID: 167718

Article Last Modified on 8/18/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q167718





SYMPTOMS
When you create a Microsoft Map in Microsoft Excel, the only symbol that is available in the Microsoft Map Control dialog box is the graduated symbol.



CAUSE
This problem occurs when the data you use to create the map uses zip codes as geographic data.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



MORE INFORMATION
If you format the first column of the data with a zip code number format, and then create a Microsoft Map on the worksheet, the only symbol you can display on the Map to represent the data is the graduated symbol.

For additional information about creating a map, please see the following article in the Microsoft Knowledge Base:

147637 XL: How to Create a Map with Microsoft Data Map

