Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 214387 - Last Review: November 5, 2003 - Revision: 4.1
XL2000: Graduated Symbol Is the Only Symbol Available in Microsoft Map
This article was previously published under Q214387
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).
This problem occurs when the data that you use to create the map uses ZIP/Postal Codes as geographic data.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
For additional information about how to create a map, click the article number below
to view the article in the Microsoft Knowledge Base:
147637Â
(http://kbalertz.com/Feedback.aspx?kbNumber=147637/EN-US/
)
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.
APPLIES TO
- Microsoft Excel 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate