How to Fix a Missing Custom Region in Excel 3D Maps
Question details
The user needs to fix an issue where a specific custom region fails to display or is completely missing in an Excel 3D Maps visualization.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a 3D Maps visualization by importing custom region files (such as KML or shapefiles).
- Observed behavior
- Most areas display correctly on the 3D Map, but one specific custom region (e.g., Highland in Scotland) is missing or not marked.
Ensure you have access to the original custom KML or shapefiles used for your 3D Map, and verify that your Excel data correctly maps to the region names defined within those files.
Verify and Update the Custom Shapefile or KML Data
The most common cause for a missing region in 3D Maps is incomplete geometry or attribute data within the imported shapefile or KML file.
Excel 3D Maps strictly relies on the geographic data provided within your custom region files. If a specific area is not drawing, the file is likely missing the exact coordinate boundaries or the associated database record for that region.
Ensure your custom region folder includes all mandatory components. A valid shapefile set must contain the SHP (geometry), SHX (index), and DBF (attribute data) files.
Open your shapefile or KML in a free GIS viewer to confirm that the missing region actually contains detailed geographic boundaries and attribute data.
In Excel, open 3D Maps, navigate to the Home tab, click 'Custom Regions', select 'Import New Set', and upload your verified shapefile or KML.

Check Data Mapping and Naming Conventions
Ensure that the region names in your Excel dataset perfectly match the attribute names defined in the custom shapefile.
Try WPS Office for Seamless Data Visualization
If you are dealing with complex Excel visualization issues or need a lightweight, cost-effective solution for everyday spreadsheet tasks, WPS Office is an excellent free alternative. It offers robust format compatibility and an intuitive interface for all your data needs.
- 1. Download the software: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up WPS Spreadsheet on your device.
- 3. Open your dataset: Double-click your existing .xlsx file to open it in WPS Spreadsheet and easily start generating built-in charts and graphs.

Frequently Asked Questions
Why does a specific region disappear when I apply a custom shapefile in Excel 3D Maps?
This usually happens because the imported shapefile (or KML) is missing the geometric boundaries or attribute data for that specific region. Without this structural data, 3D Maps cannot draw or shade the area.
What files are required for a custom region shapefile to work in Excel 3D Maps?
A functional shapefile set must include at least three files in the same folder with identical names: the .shp file (geometry), the .shx file (shape index format), and the .dbf file (attribute data).
Can I test if the issue is with my Excel data or the custom map file?
Yes. Temporarily remove or disable the custom region file in your 3D Maps settings. If the missing region successfully appears using the default Bing Maps data, the issue is directly related to missing attributes in your custom KML or shapefile.




