Chart & Visualization Issues

Fix Microsoft Excel Maps Not Recognizing Sandusky County, Ohio

Emma BrownEmma Brown Nov 13, 2026 868 views

Question details

The user needs an Excel map chart to recognize and display Sandusky County, Ohio, in a COVID-19 data visualization.

Fix Microsoft Excel Maps Not Recognizing Sandusky County, Ohio
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
Creating an Ohio county-level map from source data that includes Sandusky County.
Observed behavior
Excel initially did not recognize Sandusky County despite its presence in the source data. The user reported that entering “SanDusky” worked, and the standard spelling “Sandusky” later worked as well.
Before you start

Confirm that Sandusky County is included in the chart's source range and that its numeric value is valid. Keep Excel connected to the internet while testing, because map charts depend on online mapping data.

Solution 1Recommended

Standardize the county label and add state context

Use this first when one county is missing or Excel may be interpreting a location ambiguously.

1
Check the source row

Open the worksheet containing the map data and locate the Sandusky County row. Confirm that the county cell is populated and that the adjacent COVID-19 value is a number rather than an error or text.

2
Re-enter the county name

Click the county cell and type “Sandusky County” without leading or trailing spaces. Use consistent county naming throughout the source column.

3
Add geographic context

Add a State column containing “Ohio” and, if needed, a Country column containing “United States.” Keep the county, state, country, and value fields in separate columns.

4
Create a fresh map chart

Select the geographic columns and numeric values, then choose Insert > Maps > Filled Map. Check whether Sandusky County is now included.

Unusual capitalization is not a permanent requirement: The user reported that “SanDusky” temporarily worked, but “Sandusky” later worked too. This does not establish capitalization as the cause; a temporary mapping-data issue may also explain the behavior.
Free Microsoft Office alternative

Use WPS Office to Review and Clean Your County Data

WPS Office is a free, lightweight alternative for reviewing the spreadsheet behind your map. Its familiar interface and Excel-format compatibility make migration straightforward for everyday data editing. It does not fix Excel's mapping service, and Excel-specific filled map behavior may not be preserved.

Review county names, state labels, and numeric values before rebuilding the map in Excel.Open and edit Microsoft Excel .xlsx and .xls files.Use a familiar spreadsheet interface for everyday sorting, filtering, and data cleanup.Move everyday spreadsheet work to a free, lightweight Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel Maps recognize Sandusky County, Ohio?

Yes. Testing in the reported case showed that Excel recognized Sandusky County, and the user later confirmed that “Sandusky” worked. If it is missing from your chart, re-enter the county label, add an Ohio state column, and test through Insert > Maps > Filled Map.

Why did “SanDusky” work when “Sandusky” initially failed?

The exact cause was not confirmed. Re-entering the label may have prompted a fresh location lookup, or the mapping data may have had a temporary issue. Use the standard spelling rather than relying on unusual capitalization.

How can I stop Excel from confusing a county with a city?

Use “Sandusky County” as the county label and add separate State and Country columns containing “Ohio” and “United States.” Select those geographic fields along with your numeric values before choosing Insert > Maps > Filled Map.

What should I try if the county is missing only in one workbook?

Choose File > New > Blank workbook and create a small county, state, country, and value table. If a new filled map recognizes the county, inspect the original workbook's source range and labels, then create a fresh map from the corrected data.

Can WPS Office fix an Excel Maps location-recognition error?

No. WPS Office does not repair Microsoft Excel's mapping service. You can open the .xlsx file in WPS Spreadsheet to review and clean the source data, but use Excel to test the filled map and verify county recognition.