Fix Excel 3D Maps Not Displaying All Location Data
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.

- 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.
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.
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.
Launch 3D Maps from your Excel worksheet and look at the top of the Layer Pane on the right side of the screen.
Look for a percentage indicating 'Mapping Confidence'. If it is below 100%, click on the percentage link to open the Mapping Confidence resolution window.
Review the list of locations that could not be mapped. Excel will show you the exact state names or data rows causing the issue.
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.

Clean Data Formatting in the Value Column
Use this method if the locations are recognized but disappear specifically after you drag data into the Height or Size fields.
Isolate the Issue Using a Sample Workbook
If standard troubleshooting fails, extract the problematic data into a new file to determine if the issue is with the data structure or the workbook itself.
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.

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.




