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.
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.
- First, select any cell within the dataset. Here, we have selected cell D6.
- Then, from the Insert tab >>> select 3D Map.
- A dialog box will appear.
- Click on Enable.
- Then, the “Launch 3D Maps” window will appear.
- Select New Tour.
- Our 3D Map window will appear.
- 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.
- Secondly, select “Average Salary” inside the Height box.
- Thirdly, select “Occupation” under the Category dropdown list.
- This is what our 3D Map looks like after these steps.
- 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.”
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.
- To begin with, we will change the theme of the Map for better visualization.
- So, from the Home tab → Themes → select Modern.
- Next, if we hover over any of the Column Bar then we can see the location Data Label.
- Then, right-click on the Column Bar and select Add Annotation.
- 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.
- Thus, we create the first Data Label in the 3D Map.
- Similarly, do so for the rest of the data points, and after finishing that, the 3D Map will look like this.
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.
- To begin with, we change the theme of the Map for better visualization.
- So, from the Home tab → Themes → select “Color Black”.
- Next, we enable Map Labels.
- To do so, from the Home Tab → select 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.
- Finally, after doing all that, the 3D Map will look like this.
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.
We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.
Download Practice Workbook
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.
- How to Add Outside End Data Labels in Excel
- How to Use Millions in Data Labels of Excel Chart
- How to Show Data Labels in Thousands in Excel Chart
- How to Use Conditional Formatting in Data Labels in Excel
- [Fixed!] Excel Chart Data Labels Overlap