Microsoft KB Archive/134211

= XL7: Charts Inserted on Map Cut Off by Borders =

PSS ID Number: 134211

Article Last Modified on 10/21/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q134211





SYMPTOMS
When you use the United States (North America) map, column and pie chart objects that are added to the map will appear truncated if the chart object extends across a continental border or crosses a water boundary (such as the Great Lakes).



CAUSE
This problem occurs if you are using a map with multiple continental boundaries such as the North America map; it occurs because of the way objects are layered in Microsoft Data Map.



RESOLUTION
To resolve this problem, use any of the following methods.

Method 1: To avoid this problem, use the United States (AK & HI Inset) map option instead of the United States map option. If you want a full map of North America, do the following to add additional countries to the United States (AK & HI Inset) map:


 * 1) On the Map menu, click Add Feature.
 * 2) Select the desired geographical area, and then click OK.

Method 2: To remove the obstruction caused by the Great Lakes, use the following steps to remove the feature from the North America map.


 * 1) On the Map menu, click Features.
 * 2) In the Map Features dialog box, scroll to Great Lakes, clear the check box next to Great Lakes, and click OK.



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.

Additional query words: maps cut-off charts charting

Keywords: KB134211

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2003 Microsoft Corporation. All rights reserved.