Chart & Visualization Issues

Fix Excel Map Chart Showing County Borders Beyond Great Lakes

Tauseeq Magsi Oct 19, 2026 868 views

Question details

County boundaries on an Excel map chart are incorrectly extending into the Great Lakes instead of aligning with the actual shoreline.

Fix Excel Map Chart Showing County Borders Beyond Great Lakes

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a geographic map chart to visualize data for counties bordering the Great Lakes.
Observed behavior: The generated map chart displays county borders that extend past the actual land shoreline and into the Great Lakes water areas, reducing the accuracy of the visualization.

Before you start

Ensure you are connected to the internet, as Excel Map Charts rely on Bing Maps to render geographic boundaries. Verify that your Excel application is updated to the latest version to receive recent map data patches.

Solution 1Recommended

Refine Geographic Data Identifiers

Improve mapping accuracy by adding specific State and Country columns to give Bing Maps better context for rendering boundaries.

Excel map charts use Bing Maps to plot locations. If geographic names are ambiguous, the mapping engine may default to generic boundaries that do not reflect exact shorelines. Providing additional geographic hierarchy can force the engine to use more precise data layers.

Add a State Column

Insert a new column next to your county data in the spreadsheet and input the corresponding state (e.g., 'Michigan' or 'Wisconsin') for each row.

Add a Country Column

Add another column specifying 'United States' to ensure the global mapping service does not confuse the county names with international locations.

Update Map Data Range

Click on your existing map chart, navigate to the Chart Design tab on the ribbon, click 'Select Data', and expand your data range to include the new State and Country columns.

Improved Accuracy: Providing multi-level geographic data greatly increases the likelihood that Bing Maps will select the high-resolution boundary polygon for the affected counties.

Solution 2

Adjust Map Projection and Area Settings

Modify the chart's formatting options to restrict the mapping area or change the projection style to see if the rendering improves.

Solution 3

Submit Sample Data for Investigation

Since this specific shoreline rendering issue is often a backend Bing Maps bug, preparing and submitting sanitized data to Microsoft Support is the official recommendation.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Visualization

If you are frustrated by rendering bugs and ongoing mapping issues in Excel, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for data analysis and visualization without the hefty subscription fees.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and go to File > Open to select your existing workbook.
3. Visualize Your Data: Use the Insert tab to access a wide variety of robust charts to visualize your data accurately.

Fully compatible with Microsoft Excel (.xlsx) file formats, ensuring your data is preserved.Rich library of standard and advanced chart types for accurate data visualization.Free and lightweight, ensuring fast performance even with large datasets.Familiar user interface makes transitioning from Microsoft Office effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my map charts look distorted in Excel?

Map charts in Excel rely on the Bing Maps engine to render data. Distortion or inaccurate borders, such as those around the Great Lakes, often occur due to outdated map data on the backend or ambiguous geographic names in your dataset that confuse the mapping service.

How can I force Excel to recognize my county data correctly?

To improve accuracy, always include adjacent columns for higher-level geographic data like State and Country (e.g., 'Wayne County', 'Michigan', 'USA'). Highlighting all these columns when creating the chart provides the Bing Maps engine with enough context to map the exact region.

Can I manually edit the borders of an Excel map chart?

No, the boundary lines in Excel map charts are generated automatically by Bing Maps and cannot be manually drawn, adjusted, or edited within the chart itself.

Excel & Data Problems