How to Create Tree Map Charts in Google Sheets
Learn how to create Tree Map Charts in Google Sheets through our easy & stress-free guide 😌
Why use Tree Map Charts In Google Sheets
It often becomes difficult to represent relationships amongst categories when working with lots of data. Tree Map Charts are often useful in representing parent-child relationships between different data items and are usually used for the classification of data in Google Sheets.
Each category of data is represented in the form of rectangles in Tree Map Charts in Google Sheets and each of these rectangles has a specified size and colour. This makes the data easier to understand and interpret.
Tree Maps are considered better than Pie Charts primarily because the human mind finds it easier to perceive the rectangles present in a Tree Map chart versus the wedges that are present in a Pie Chart. Since most reports involve a breakdown view of data, creating Tree Map Charts in Google Sheets as against Pie Charts might just be a quick way for you to score some extra brownie points with your manager! 😎
Formatting the Data
In order to create Tree Map Charts in Google Sheets, your data should follow a particular format. As shown below, for this article, I have considered an example of the different types of majors taught at a university.
As you can see the data shown above consists of three columns in the following format-
- First column– This column consists of the objects for which the Tree Map Chart is to be created. Objects should follow a hierarchy where the first record is the parent and the succeeding records are the subcategories and their corresponding objects.
- Second column – This column specifies the parent for each entity. For instance, the parent for the major Mathematics is Bachelor of Sciences.
- Third column – This column consists of a positive numeric value for each object and the sum of these values is indicated at the top of the column.
- Fourth column (optional) – Can be included to specify a positive numeric value indicating the color of the rectangular boxes.
Now that we have prepared our data, let’s move on to actually creating Tree Map Charts in Google Sheets.
Creating Tree Map Charts in Google Sheets
- Select the data.
- Click Insert-> Chart.
- From the Chart Editor, select Tree Map Chart.
- A Tree Map Chart appears on the screen.
- Hover your cursor over an item in the chart, to see its value.
- If you double click on a particular header (the ones shaded in blue), you can zoom in to that area. For example, as shown below clicking on the Bachelor of Arts header zooms the entire region for me.
Next, let’s see how you can customize your Tree Map Chart to make it more visually appealing.
Customizing Tree Map Charts in Google Sheets
You can make modifications in your Tree Map Chart by navigating to the Setup or Customize section in the Chart Editor of Google Sheets. Let’s go through the type of customizations each section allows you to make in the chart.
- The Setup section-
As shown below this section allows you to configure the data series of your chart.
- Data range – Refers to the cell range for which we are creating the Tree Map Chart.
- ID – Refers to all the selected cells in the first column of the data which act as entitle for the tree map chart.
- Parent – Refers to all the parent cells in the second column of the data.
- Size – Contains the cell range of the objects’ numeric values.
- Color – If a fourth column is present in the data, this field will refer to the cell range of the numeric values that represent the color of the rectangular boxes.
- The Customize section-
This section makes changes in the visual appearance of your chart.
- Chart style – In this section, you can modify the background color, border color, and font of your tree map chart.
- Tree map – Here, you can customize the font, font size, format, and text color for your objects. Moreover, this section also allows you to set the header color and the colors of the various objects depending on their min, mid and max values.
To illustrate this I have changed the min value and mid value colors for the Tree Map Chart.
After making the above change, this is what the new chart looks like.
- Chart & axis titles – Add titles to your tree map chart by navigating to this section.
To demonstrate this, I have specified the chart title in the title text input box. As you can see in the figure below the corresponding title gets added to the chart.
- Gantt Charts in Google Sheets: Learn how to create Gantt Charts in Google Sheets.
- Waterfall Charts in Google Sheets: An easy guide to help you create Waterfall Charts in Google Sheets.
- Radial Bar Charts in Google Sheets: More on how to generate Radial Bar Charts in Google Sheets.
- Candlestick Charts in Google Sheets: Quick guide to teach you how to create Candlestick Charts in Google Sheets.