How to Create Custom Regions in Excel 3D Maps (Easy Steps)

 

Step 1 – Access Google My Maps

  • Visit the Google My Maps website.
  • Click Create a New Map to begin customizing your territories.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps


Step 2 – Set Up Layers for Your Map

  • Use the search box to find a specific location (e.g., New York City).

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Click on the city to view it on the map.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Remove any existing green indicators by clicking the plus (+) sign.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • The blue location icon will now represent your chosen area.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps


Step 3 – Define Custom Territories

  • Under the search bar, locate the Draw a line option.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Choose Add line or shape from the drop-down menu.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Use the cursor to draw polygons by connecting angular positions.
  • Title each customized region (e.g., New York).
  • Zoom in for accuracy.
  • Save your work.

  • Follow the earlier step to continue creating and titling all the customized regions.


Step 4 – Share Your Created Map

  • Click Share.

  • Add names and descriptions.
  • Specify the map title (e.g., City Map).
  • Click OK.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Enable sharing options.
  • Click Close to complete the process.

Read More: How to Enable 3D Maps in Excel


Step 5 – Export KML File for Custom Regions in 3D Maps

  • Click on the three dots located on the right side of the Untitled map.
  • From the vertical menu, select Export to KML/KMZ.

  • In the download window, ensure you choose Export as KML (instead of KMZ) to maintain compatibility with custom regions in Excel 3D maps.
  • Click the Download button.

  • Save the file to your desired folder.


Step 6 – Open 3D Maps in Excel

  • Access your Excel workbook.
  • Open a blank sheet.
  • Go to the Insert tab on the ribbon.
  • Under the Tour category, click the 3D Maps drop-down menu and select Open 3D Maps.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • The Launch 3D Maps dialog box will appear.
  • Click New Tour to display the workbook 3D Maps window.

Read More: How to Change Data Source of Excel 3D Maps


Step 7 – Create Custom Regions

  • In the 3D Maps window, go to the Home tab on the ribbon.
  • Click the Custom Regions menu within the Map group.

  • The Manage Custom Region Set dialog box will appear.
  • Click Import New Set.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Navigate to the folder where your spreadsheet data is saved.
  • Select the KML file created using Google My Maps and click Open.
  • Instead of clicking on the Open button, you can select the file and double-click on the file to import it to create the map.

  • The Import Custom Region Set window will pop up.
  • Click Import.

Step-by-Step Procedures to Create Custom Regions in Excel 3D Maps

  • Return to Custom Regions and choose the City Map region set.
  • Click Regions.

  • The City Map window will appear.
  • Click Copy All Items.


Step 8 – Prepare Your Excel Workbook

  • Paste the copied data from the City Map into your Excel workbook.
  • Add a title, headings, and include the population column as needed.
  • Highlight the entire dataset.


Step 9 – Generate 3D Visualization with Customized Data

  • Go to the Insert tab on the ribbon.
  • Under the Tour group, click the 3D Maps drop-down menu.
  • Select Add Selected Data to 3D Maps (ensure the data is selected).

  • You’ll be taken back to the 3D Maps window.
  • Drag the Population (M) from the Field List (Range1) to the height section of the map.
  • Similarly, drag City Name as the category for your map.
  • In the Location option, choose Custom Region (.kml, .shp).


Final Output

You’ll now be able to view custom regions in Excel 3D maps. Feel free to adjust color and opacity settings as needed.

Create Custom Regions in Excel 3D Maps


Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Excel Power Map Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

2 Comments
  1. I tried following along until I got to the part where I need to set my regions. The REGIONS button is missing. What do I do?

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo