Chart & Visualization Issues

Fix Excel 3D Maps Not Displaying All Location Data

Amos GikundaAmos Gikunda Oct 10, 2026 869 views

Question details

The user needs to resolve an issue where certain geographic locations disappear from Excel 3D Maps when numerical data is added to the size or height fields.

How to Fix Excel 3D Maps Missing Location Data
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating a 3D Map visualization with geographic fields (states) and associated value metrics (employee counts).
Observed behavior
State labels display correctly at first, but specific locations disappear entirely from the map once employee counts are added to the size or height fields, despite valid data existing in the source worksheet.
Before you start

Verify that your geographic location column is strictly formatted as Text and your value column (like employee counts) is formatted as Numbers without any hidden text characters or leading spaces.

Solution 1Recommended

Check Mapping Confidence and Fix Unrecognized Locations

Use this solution to identify and correct locations that Bing Maps cannot accurately plot when linked with specific height or size metrics.

Excel 3D Maps relies on Bing Maps to geocode locations. If geographical names are ambiguous or slightly misspelled, they might render as labels but fail to plot properly when a structural data point (like height) is attached. Checking the Mapping Confidence helps pinpoint these drop-offs.

1
Open the 3D Maps Layer Pane

Launch 3D Maps from your Excel worksheet and look at the top of the Layer Pane on the right side of the screen.

2
Review Mapping Confidence

Look for a percentage indicating 'Mapping Confidence'. If it is below 100%, click on the percentage link to open the Mapping Confidence resolution window.

3
Identify Unmapped Data

Review the list of locations that could not be mapped. Excel will show you the exact state names or data rows causing the issue.

4
Update Source Data

Return to your Excel worksheet and correct the spellings, or add an additional column (like 'Country/Region') to provide more context to Bing Maps, then click 'Refresh Data' in 3D Maps.

Check Mapping Confidence and Fix Unrecognized Locations
Pro Tip: Always include a Country/Region column alongside your State/Province column to prevent Bing Maps from confusing states with identically named cities in other countries.
Free Microsoft Office alternative

Try WPS Office for Reliable Data Visualization

If you frequently encounter missing data issues with complex Excel add-ins like 3D Maps, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet experience with robust built-in charting tools to visualize your data efficiently, without the heavy processing errors associated with advanced geographic plugins.

Fully compatible with Microsoft Excel formats including .xlsx and .csvOffers reliable 2D charts and data visualization templates without needing complex add-insFree to download and uses significantly fewer system resourcesFamiliar user interface ensuring a seamless migration with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel 3D Maps show mapping confidence errors?

Mapping confidence errors occur when Bing Maps cannot accurately identify a geographic location based on the provided text. Adding more specific columns to your source data, such as Country, State, and Zip Code, significantly improves the mapping accuracy.

Can I use Excel 3D Maps offline to prevent data drop-offs?

No, Excel 3D Maps requires an active internet connection to communicate with Bing Maps. If your connection drops, the map may fail to geocode locations and data points will disappear.

How do I force 3D Maps to update after I fix my data?

In the 3D Maps window, navigate to the Home tab on the ribbon and click the 'Refresh Data' button. This forces the map to pull the most recent data and formatting changes from your source Excel worksheet.