Chart & Visualization Issues

Fix Excel Map Chart Problems with Washington D.C. and U.S. Counties

Jason MillerJason Miller Oct 23, 2026 870 views

Question details

Excel Map Charts fail to identify specific U.S. locations, such as Washington, D.C., and certain Alaska census areas.

How to Fix Excel Map Chart Problems with Washington D.C. and U.S. Counties
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating Map Charts using U.S. geographic data.
Observed behavior
The Map Chart does not accurately plot Washington, D.C., or certain counties due to Bing geocoding errors or missing geographical hierarchy in the data.
Before you start

Ensure you have an active internet connection so the Bing geocoding service can process your geographic data, and verify that your data is organized into clear columns.

Solution 1Recommended

Structure Geographic Data Hierarchy for Bing Geocoding

Restructure your dataset to include distinct columns for country, state, and county to ensure Bing accurately maps locations like Washington, D.C.

Excel Map Charts rely heavily on Bing's geocoding service, which requires unambiguous column headers and a proper geographical hierarchy. If locations are placed in the wrong administrative level, Bing will fail to map them.

1
Add specific geographical columns

Insert separate columns in your spreadsheet and label them exactly as 'Country', 'State/Province', and 'County'.

2
Format Washington, D.C. correctly

For Washington, D.C., enter 'USA' in the Country column, and 'Washington, D.C.' in the State/Province column.

3
Define the county-level location

Instead of entering 'District of Columbia', enter 'City of Washington' in the County column.

4
Regenerate the Map Chart

Highlight your newly formatted data table, navigate to the Insert tab on the Excel ribbon, click Maps, and select Filled Map to generate the updated chart.

Structure Geographic Data Hierarchy for Bing Geocoding
Bing Geocoding Sensitivity: Map Charts are highly sensitive to column names. Always include a Country column, even if all your data is from the U.S., so the Bing service can distinguish the locations correctly.
Free Microsoft Office alternative

Experience Hassle-Free Data Visualization with WPS Office

If Excel's Bing geocoding continues to cause map chart errors, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with powerful data visualization tools and seamless Microsoft Excel (.xlsx) file support.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file.
  3. 3. Visualize Your Data: Navigate to the Insert tab to explore a wide variety of robust charting options for your geographic data.
100% compatible with Microsoft Excel (.xlsx) formatsRich built-in chart types for diverse data visualizationFree and lightweight alternative to Microsoft OfficeFamiliar user interface with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why is Excel mapping Washington, D.C. incorrectly?

Excel uses Bing geocoding, which classifies Washington, D.C., as a state or province. If you place it in the county column or use 'District of Columbia', Bing may fail to identify and map the location.

How do I fix Alaska census areas not showing on the Map Chart?

Ensure your geographic data includes a 'Country' column set to 'USA' and a 'State/Province' column set to 'Alaska'. Use the exact accepted names for the specific boroughs or census areas in your 'County' column.

Do I need an internet connection to create an Excel Map Chart?

Yes. Excel sends your geographic data to Bing's online geocoding service to plot the map. Map charts will not render or update correctly while offline.

Can I use custom geographic regions in Excel Map Charts?

Excel Map Charts only support standard, high-level geographic entities like countries, states, counties, and postal codes. Custom geographic boundaries or territories are not natively supported.