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.
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.
📌 Step 02: Add Data Labels from Chart Elements
- Second, click the Chart Elements option >> enable the Data Labels option.
Voila! Just like that, we’ve added the data labels. It’s that simple.
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.
Now, this opens the Format Data Labels pane.
- Next, enable the Series Name option.
Finally, the results should look like the figure shown below.
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.
- Then, in the Format Data Labels pane, check the Category Name option.
Lastly, this should categorize the various items as shown in the screenshot below.
3. Showing Value in Chart
- First of all, proceed to the More Data Labels Option by following the steps shown prior.
Eventually, this opens the Format Data Labels window.
- At this point, click the Value option.
Consequently, this results in the output shown in the picture below.
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.
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.
- 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.
- Not long after, switch 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.
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.
- 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.
- Fourth, choose the Series Options >> click on Banner.
Finally, after completing the above steps, the final result appears in the picture below.
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.
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.