Chart & Visualization Issues

How to Fix a Missing Custom Region in Excel 3D Maps

Huma Ashraf ChHuma Ashraf Ch Nov 3, 2026 869 views

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.

How to Fix a Missing Custom Region in Excel 3D Maps
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.
Before you start

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.

Solution 1Recommended

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.

1
Check your Shapefile components

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.

2
Verify region data using a GIS viewer

Open your shapefile or KML in a free GIS viewer to confirm that the missing region actually contains detailed geographic boundaries and attribute data.

3
Re-import the custom regions

In Excel, open 3D Maps, navigate to the Home tab, click 'Custom Regions', select 'Import New Set', and upload your verified shapefile or KML.

Verify and Update the Custom Shapefile or KML Data
Test with Default Regions: If you remove the custom region file, Excel 3D Maps might display the region using its default Bing Maps data, confirming the issue lies exclusively within your custom file.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and click the free download button.
  2. 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up WPS Spreadsheet on your device.
  3. 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.
100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Built-in robust 2D chart and standard map chart capabilities for clear data visualization.Lightweight installation with fast loading times for large datasets.Familiar user interface ensuring a seamless migration from Microsoft Office.
microsoft office alternative - wps office

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.