# Create Treemap Chart to Show Values in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

## Conclusion

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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF