Chart & Visualization Issues

Fix Excel Filled Maps Showing the Entire World Instead of a State

Ayan Masood Oct 9, 2026 870 views

Question details

The user needs to restrict an Excel filled map to show a specific region, such as Washington State, rather than zooming out to display the entire globe.

How to Fix Excel Filled Maps That Display the Entire World

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a filled map chart using county-level data for a specific state.
Observed behavior: The filled map chart incorrectly displays the entire world because the geographical data, such as county names, is ambiguous or unrecognized by Excel.

Before you start

Ensure you have an active internet connection, as Excel requires it to look up and resolve geographic locations using the Bing Maps service.

Solution 1Recommended

Convert Data to the Geography Data Type

Resolving ambiguous county names by linking them to Excel's Geography data type ensures the map accurately plots the regions and zooms into the correct state.

Excel maps rely on Bing to identify locations. When you use generic county names, Bing might match them to places outside your target state. Converting the text to a Geography data type forces Excel to verify each location.

Select the geographic data

Highlight the column in your spreadsheet that contains the geographic names, such as the list of counties.

Apply Geography data type

Navigate to the 'Data' tab on the Excel ribbon and click on 'Geography' within the 'Data Types' group.

Resolve ambiguous locations

Wait for Excel to process the text. If a question mark icon appears next to any name, click it to open the Data Selector pane. Search for a more specific term (e.g., 'King County Washington') and select the correct match.

Insert the Filled Map

Select both your updated geographic data column and the corresponding values column, then go to 'Insert' > 'Maps' > 'Filled Map' to generate the corrected chart.

Data Structuring Tip: If you have many duplicate county names across states, create a helper column that concatenates the county and state (e.g., =A2 & ", " & B2) before converting it to the Geography data type.

Free Microsoft Office alternative

Create Stunning Data Visualizations with WPS Office

If you are struggling with complex Excel data types and map chart errors, try WPS Office. It provides a lightweight, highly compatible spreadsheet editor with an intuitive interface for creating professional charts and visualizing data seamlessly without the heavy subscription fees.

1. Download and install: Get WPS Office for free from the official website and install it on your device.
2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about formatting loss.
3. Visualize your data: Select your dataset and use the Insert tab to easily create and customize beautiful charts.

Completely free and lightweight alternative to Microsoft Excel.High compatibility with Microsoft Office formats, including .xlsx, .xls, and .csv.Familiar user interface that requires no steep learning curve.Rich selection of built-in chart types for all your data visualization needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel map chart show the wrong country or state?

This happens when the location names in your data are ambiguous. For example, a county name might exist in multiple states or countries. Excel's mapping feature may guess incorrectly unless you specify the exact state or country.

How do I force an Excel map to zoom in on one state?

Ensure all geographic data points are correctly recognized using the Geography Data Type. Then, double-click the map series in the chart to open the Format Data Series pane, and set the 'Map Area' option to 'Only regions with data'.

Does the Geography data type require a Microsoft 365 subscription?

Yes, the Geography data type and advanced map chart features are primarily available in Microsoft 365. They also require an active internet connection to retrieve map data from the Bing service.

What should I do if the Geography data type gives me a question mark icon?

A question mark indicates Excel cannot confidently match your text to a specific location. Click the question mark icon to open the Data Selector pane, then manually type a more specific location, such as 'King County, Washington', to resolve it.

Excel & Data Problems