How to Show Data Labels in Excel 3D Maps (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to show Data Labels in Excel 3D Maps? Then this is the article for you. Excel does not provide a Show Data Labels option inside the 3D Maps. However, we will show you 2 workarounds to do so in this article.


How to Show Data Labels in Excel 3D Maps: 2 Handy Approaches

To demonstrate the methods, we have picked a dataset with 3 columns: “Occupation“, “Location“, and “Average Salary“. This dataset represents the mean salary of 6 occupations for each different location, and we are going to use this data to show you how to enable Data Labels in 3D Maps.

Data Labels in Excel 3D Maps 1

Read More: How to Add Data Labels in Excel


Create a 3D Map in Excel

Before, showing the methods of how to show Data Labels in 3D Maps, we will demonstrate to you the steps to create a 3D Map in Excel.

Steps:

  • First, select any cell within the dataset. Here, we have selected cell D6.
  • Then, from the Insert tab >>> select 3D Map.

Data Labels in Excel 3D Maps 2

  • A dialog box will appear.
  • Click on Enable.

Data Labels in Excel 3D Maps 3

  • Then, the “Launch 3D Maps” window will appear.
  • Select New Tour.

Data Labels in Excel 3D Maps 4

  • Our 3D Map window will appear.

Data Labels in Excel 3D Maps 5

  • We can see the “Layer Pane” on the right side of the screen. Here, we will modify our 3D Map settings.
  • First, change the type of the “Location” column to “State/Province” by clicking on the dropdown list.

Data Labels in Excel 3D Maps 7

  • Secondly, select “Average Salary” inside the Height box.

Data Labels in Excel 3D Maps 8

  • Thirdly, select “Occupation” under the Category dropdown list.

Data Labels in Excel 3D Maps 9

  • This is what our 3D Map looks like after these steps.

Data Labels in Excel 3D Maps 10

  • Moreover, our dataset will contain a message of 3D Maps

3D Maps Tours. 

This workbook has 3D Maps tours available. 

Open 3D Maps to edit or play the tours.

Data Labels in Excel 3D Maps 11

Thus, we can create a 3D Map in Excel.


1. Adding Annotation to Show Data Labels in Excel 3D Maps

In this section, we will use the Add Annotation feature to make Data Labels in Excel 3D Maps.

Steps:

  • To begin with, we will change the theme of the Map for better visualization.
  • So, from the Home tab → Themes → select Modern.

Data Labels in Excel 3D Maps 12

  • Next, if we hover over any of the Column Bar then we can see the location Data Label.

Data Labels in Excel 3D Maps 13

  • Then, right-click on the Column Bar and select Add Annotation.

Data Labels in Excel 3D Maps 14

  • Afterward, a dialog box will appear.
  • Then, type “Kansas” inside the TITLE box and we can see a preview of it on the right side.
  • After that, press OK.

Add Annotation

  • Thus, we create the first Data Label in the 3D Map.

Single Data Label

  • Similarly, do so for the rest of the data points, and after finishing that, the 3D Map will look like this.

Data Labels in Excel 3D Maps

Read More: How to Add Additional Data Labels to Excel Chart


2. Enabling Map Labels to Create Data Labels in Excel 3D Maps

For the last method, we will turn on the Map Labels feature to show the Data Labels in 3D Maps.

Steps:

  • To begin with, we change the theme of the Map for better visualization.
  • So, from the Home tab → Themes → select “Color Black.

Themes

  • Next, we enable Map Labels.
  • To do so, from the Home Tab → select Map Labels.

Map Labels

  • Then, from the Layer Pane, select Bubble under the Data visualization type.
  • After that, we lower the opacity Bubble to make the Map Labels visible.

Layer Pane

  • Finally, after doing all that, the 3D Map will look like this.

Data Labels 2

Read More: How to Edit Data Labels in Excel


Things to Remember

  • First, the 3D Map feature is only available on the Windows platform and from Excel 2013. Therefore, the earlier versions will not have access to this feature, and you cannot use this feature on Apple’s OS.
  • Next, it was known as Power Map in Excel 2013. Later, Microsoft renamed it 3D Map.
  • Lastly, if we create a 3D Map in Excel 2016, it will not be compatible with Excel 2013.

Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Download Practice Workbook


Conclusion

We have shown you 2 handy approaches to how to show data labels in Excel 3D maps. If you face any problems regarding these methods or have any feedback for me, feel free to comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Greetings! I am Rafiul, an experienced professional with an engineering degree and an MBA in finance. Data analysis is my passion, and I find Excel to be an invaluable tool in this domain. My goal is to simplify complex concepts by providing comprehensive and user-friendly guides on Excel and finance topics, aiming to enhance people's productivity and understanding at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo