Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Add and Format Data Labels in Excel Treemap

Unquestionably, Excel has an intuitive and convenient graphing engine that can add stunning visuals and breathe new life into any dataset. For instance, you may have a hierarchical dataset that you want to represent in a Treemap. Additionally, you may want to add data labels to your treemap chart in Excel. Fortunately, in this article, we’ll describe how to add data labels to Treemap in Excel. Moreover, we’ll also learn to make a treemap with multiple levels.


Download Practice Workbook


How to Add and Format Data Labels in Treemap Chart in Excel

First of all, let’s consider the Sales Dataset shown in the B4:C12 cells which contains the names of Items and their corresponding Sales in USD. Here, we want to insert a Treemap chart and then add data labels to the treemap in Excel. Therefore, let’s explore all the nitty-gritty and see each step with the appropriate illustration.

excel treemap data labels

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.


2 Steps to Add Data Labels in Excel Treemap

In the following section, we’ll go through the steps to insert a Treemap chart in Excel and add the data labels to it. Hence, just follow along.


📌 Step 01: Insert Treemap

  • First, go to the Insert tab >> click the Insert Hierarchy Chart drop-down >> choose the Treemap chart option.

Insert Treemap

Read More: How to Create Hierarchy Tree from Data in Excel (3 Examples)


📌 Step 02: Add Data Labels from Chart Elements

  • Second, click the Chart Elements option >> enable the Data Labels option.

Add Data Labels from Chart Elements

Voila! Just like that, we’ve added the data labels. It’s that simple.

adding Excel treemap data labels


4 Ways to Format Data Labels in Excel Treemap

Obviously, after adding we may want to edit the data labels, so in the following segments, we’ll discuss how to add Series Name, Category Name, Value, and Show Numbers in Excel Treemap chart.


1. Working with Series Name

  • To begin with, select the chart >> click the Chart Elements option >> in the Data Labels option, choose More Data Label Options.

Working with Series Name

Now, this opens the Format Data Labels pane.

  • Next, enable the Series Name option.

Adding Series Name

Finally, the results should look like the figure shown below.

adding series name in excel treemap data labels


2. Dealing with Category Name

  • First and foremost, click on the chart >> press the Chart Elements button >> navigate to Data Labels >> select More Data Label Options.

Dealing with Category Name

  • Then, in the Format Data Labels pane, check the Category Name option.

Adding category name

Lastly, this should categorize the various items as shown in the screenshot below.

Adding category name with excel treemap data labels


3. Showing Value in Chart

  • First of all, proceed to the More Data Labels Option by following the steps shown prior.

Showing Value in Chart

Eventually, this opens the Format Data Labels window.

  • At this point, click the Value option.

Enabling value option

Consequently, this results in the output shown in the picture below.

enabling value with excel treemap data labels

Read More: Create Treemap Chart to Show Values in Excel (with Easy Steps)


4. Engaging with Number Option

  • In the first place, navigate to the D5 cell >> enter the following expression into the Formula Bar >> use the Fill Handle tool to copy the formula into the cells below.

=C5/SUM($C$5:$C$12)

In this situation, the C5 cell refers to the “Blender Sales of $3,056” while the C5:C12 range of cells represents the “Sales” column.

📃 Note: Please make sure to use Absolute Cell Reference by pressing the F4 key on your keyboard and change the cell formatting to a percentage by pressing CTRL + SHIFT + 5 keys.

Engaging with Number Option

  • In turn, jump to the Insert tab >> choose the Treemap chart option.

  • Afterward, use the Chart Elements option to move to More Data Label Options.

Formatting chart

  • Not long after, switch on the Category Name and Value options >> choose the Percentage option.

switching on the Category Name and Value options choose the Percentage option.

Subsequently, the final output displays the percentage of “Total Sales” represented by each item.

adding number option with excel treemap data labels

Read More: How to Change Treemap Order in Excel (with Easy Steps)


How to Add Multiple Levels in Excel Treemap

For one thing, we can add multiple levels to our Treemap chart in Excel. Now, let’s assume the Categorized Sales Dataset shown in the B4:D15 cells, which depicts the Category, the Item, and the Sales in USD.

How to Add Multiple Levels in Excel Treemap

📌 Steps:

  • To start with, proceed to the Insert tab >> select the Treemap chart option.

  • Second, press Chart Elements >> go to More Data Labels Options.

  • Third, insert check marks for the Category Name and Value options.

Selecting Category Name and Value option

  • Fourth, choose the Series Options >> click on Banner.

Checking Banner option

Finally, after completing the above steps, the final result appears in the picture below.

excel multiple level treemap data labels


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section excel treemap data labels


Conclusion

To sum up, we hope this article helps you understand how to add data labels to Treemap in Excel. Now, if you have any queries, please leave a comment below. And, visit our website ExcelDemy to read more articles like this.

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo