When dealing with lots of data, we often represent the data in a chart form in business meetings or to the viewers or readers. The most commonly used chart is the Treemap Chart in Excel. However, the chart is actually meant to exhibit hierarchical data. Moreover, it represents different portions of data in different portions, which makes the data much more attractive and easy to understand for viewers and readers. So, it is essential to learn how to insert a treemap chart showing values in Excel. In this article, I will show you a step-by-step procedure to create a Treemap Chart showing values in Excel.
What Is a Treemap Chart?
The Treemap in Excel is a common type of chart that provides a hierarchical representation of the data. Usually, this type of chart uses rectangular boxes, which serve as branches to represent data within groups. Moreover, this type of chart is very useful for comparing products and depicting the best-selling ones, and the relationship that exists between the data is actually a one-to-many relationship. Generally, a Treemap consists of 3 major sections.
Plot Area: This is the portion where we generate the visual representation of the data. However, each rectangle has a label marking the name of the group.
Chart Title: Here, you can give a descriptive name to the chart and place it in a suitable location.
Legend: Generally, this section denotes the color of each data category to make it easy to compare them.
Read More: How to Make a Treemap Chart in Excel
How to Create Treemap Chart to Show Values in Excel: Step-by-Step Procedure
However, you want to create a Treemap Chart to show the sales value of various products in Excel. Moreover, the task is quite simple and easy. If you follow the below steps correctly, you will learn how to create a treemap chart showing values in Excel. So, without further delay, let’s see the process in detail.
📌Step 1: Select Dataset
Initially, I am keeping all the cells in general format. In this case, I have 3 unique columns, which are Country, Product, and Sales (units). However, you can vary the number of columns later on if that is needed. For the purpose of demonstration, I have used the following sample dataset.
📌Step 2: Insert Treemap Chart
Fortunately, you have created the data table; you now need to go through the steps to generate the treemap chart with the multiple levels of data groups. Follow the steps below to achieve this.
- Firstly, select the dataset.
- Secondly, go to the Insert tab and move to Insert Treemap Chart.
- Thirdly, click on Treemap Chart.
- Lastly, you will get the Treemap Chart.
Read More: How to Change Treemap Order in Excel
📌Step 3: Modification and Final Output
- Initially, you can add a Chart Title, Data Labels, and Legend from Chart Elements.
- Then, select Data Labels and press Ctrl + 1 to open the Format Data Labels pane.
- In turn, insert a check for both Category Name and Value options.
- Finally, you will get the Treemap Chart as in the image below.
- However, you can add a Banner from the Format Data Series.
- In addition, after making some changes in color, the chart will look better.
💬 Things to Remember
- Initially, to find the Treemap Chart option, you have to select the dataset, go to the Insert Tab, and select the Recommended Chart.
- Then, you can choose any type of data with sub-divisions in order to draw the chart.
- Next, data labeling and chart titles are essential in this chart. Otherwise, the chart can be misleading sometimes.
- After that, you can format the chart as you wish by going to the Chart Design option.
- Lastly, legends in the chart must be put in a way that helps to understand the data.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
These are all the steps you can follow to create an Excel Treemap chart to show values. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.