Tree Map Charts in Google Sheets 🌴 | Best Guide (2022)

Tree Map Charts in Google Sheets 🌴 | Best Guide (2022)
Reading Time: 5 minutes

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.

Data in Google Sheets for Tree Maps
Fig 1: Data to create Tree Map Charts In Google Sheets

As you can see the data shown above consists of three columns in the following format-

  1. 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.
  2. Second column – This column specifies the parent for each entity. For instance, the parent for the major Mathematics is Bachelor of Sciences. 
  3. 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.
  4. 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. 
Selecting data to create Tree Map Charts in Google Sheets
Fig 2: Select the data | Example for Tree Map Chart in Google Sheets
  • Click Insert-> Chart
Inserting a Chart to create Tree Map Charts in Google Sheets
Fig 3: Insert chart | Example for Tree Map Charts in Google Sheets
  • From the Chart Editor, select Tree Map Chart
Selecting Tree Map Charts in Google Sheets
Fig 4: Select Tree Map Chart | Example for Tree Map Chart in Google Sheets
  • A Tree Map Chart appears on the screen. 
What Tree Map Charts in Google Sheets look like
Fig 5: Sample Display of Tree Map Charts in Google Sheets
  • Hover your cursor over an item in the chart, to see its value.
Hover cursor over an item to see its value in the Tree Map Charts in Google Sheets
Fig 6: Hover cursor over your Tree Map Chart in Google Sheets
  • 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. 
Zooming in on a header in Tree Map Charts in Google Sheets
Fig 7: Zoom in on a particular header of your Tree Map Chart in Google Sheets

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. 

  1. 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.
  1. 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. 

Changing colors in a Google Sheets Tree Map Chart
Fig 8: Changing the colors

After making the above change, this is what the new chart looks like.

Tree Map Chart in Google Sheets with new colors
Fig 9: Tree Map Chart with new colors
  • 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. 

Adding title to a Tree Map Chart in Google Sheets
Fig 10: Chart title added

See Also