Chart & Visualization Issues

How to Fix Missing States in an Excel Filled Map Chart

Kushani Nimanthika Oct 1, 2026 869 views

Question details

The user needs to resolve an issue where certain states are left blank or unrecognized when creating a Filled Map chart in Excel.

How to Fix Missing States in an Excel Filled Map Chart

Product: Microsoft Excel
Device & OS: not provided
Scenario: Visualizing geographic data with an Excel Filled Map chart.
Observed behavior: The resulting map chart leaves certain states blank because the location names are ambiguous, inconsistently formatted, or not recognized by the map service.

Before you start

Ensure you have a stable internet connection, as Excel's mapping feature requires access to online Bing Maps services to accurately process and plot geographical data.

Solution 1Recommended

Clean Location Data and Apply the Geography Data Type

Format your location names consistently, provide country context, and convert the text to the Geography data type to ensure accurate mapping.

Excel map charts rely on an external map service (Bing Maps) to translate text into geographic territories. When location names are ambiguous—such as using abbreviations that might match cities globally—the service may fail to assign the territory, leaving the state blank. Providing explicit country context and formatting the text properly resolves this issue.

Standardize state names

Ensure your data table has exactly one state per row. Replace any state abbreviations (e.g., 'TX' or 'CA') with their full names ('Texas', 'California') and delete any leading or trailing spaces in the cells.

Add a country column

Insert a new column directly next to your state names. Title it 'Country' or 'Region' and type 'United States' (or the relevant country) into every row corresponding to a state.

Apply the Geography data type

Select the column containing your state names. Navigate to the 'Data' tab on the Excel ribbon, locate the 'Data Types' group, and click on 'Geography'. Excel will automatically fetch geographic coordinates.

Recreate the Filled Map chart

Highlight your updated data range, including the new Country column and any numeric values. Go to the 'Insert' tab, click on 'Maps', and select 'Filled Map' to generate a complete chart with no missing states.

Clean Location Data and Apply the Geography Data Type

Verification: Once the Geography data type is applied successfully, a small map icon will appear inside the cell next to the state name, confirming that the location is recognized.

Free Microsoft Office alternative

Try WPS Office for Hassle-Free Data Visualization

Struggling with complicated data types and mapping errors in Microsoft Excel? Switch to WPS Office. It is a powerful, lightweight, and completely free alternative that allows you to manage data and create stunning visualizations with ease.

1. Download and Install WPS Office: Visit the official WPS Office website to download the free suite and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing Excel workbooks to access your data.
3. Create Visualizations: Select your data range, go to the 'Insert' tab, and choose from a wide variety of charting options to bring your data to life.

Completely free and lightweight, ensuring fast performance on any deviceFully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvRich selection of built-in chart templates to visualize data without complex setupsFamiliar interface design ensures a seamless transition with zero learning curve

Frequently Asked Questions

Why does my Excel map chart show missing data for certain states?

Location names may be ambiguous, improperly abbreviated, or lack a broader country context. Excel uses Bing Maps to plot these locations, and without clear identifiers (like full state names alongside a Country column), the service cannot accurately map the territory.

Do I need an internet connection to use Excel Map Charts?

Yes. Excel requires an active internet connection to transmit your location data to the Bing Maps service, which processes the text and returns the geographical polygons necessary to render the map.

Can I use state abbreviations instead of spelling out the full state name?

While Excel can occasionally map standard abbreviations, relying on them often leads to errors because abbreviations might match city or region names in other countries. Using full, correctly spelled state names is always recommended for accurate map charts.

Excel & Data Problems