XL7: Mixed-Case GeoData Labels Cause Incorrect Maps

Last reviewed: March 27, 1997
Article ID: Q134210
7.00 WINDOWS kbtool

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

If you use uppercase labels mixed with lowercase labels in a GeoData column of map data, data related to the items in uppercase letters may not be drawn on the map. This problem will also affect data in the cells directly above the capitalized labels.

The GeoData column usually contains the names of states or countries, or other types of geographical information.

RESOLUTION

To avoid this problem, use either of the following methods:

Method 1: Place uppercase column headings at the beginning of the data

          columns with lowercase headings.

Method 2: Use the same case for all labels in the GeoData column.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


KBCategory: kbtool
KBSubcategory:

Additional reference words: 7.00
Keywords : kbtool
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.