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.


Download Practice Workbook


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

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


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 Data Labels in Excel (2 Handy Ways)


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 Add Two Data Labels in Excel Chart (with Easy Steps)


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


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. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo