Use a tree map when you want to show a data tree, where objects are organized into parent-child hierarchies. For example, show the average annual sales of each item in a product category.
Learn how to add & edit a chart.
How to format your data
- First column: Enter the name of an object in your hierarchy.
- Second column: Enter the name of the object’s parent. The parent name must also appear in the first column.
- Third column: Enter a positive numeric value for each object. This value determines the size of each box. The aggregate total for the parent name must also be in the third column.
- Fourth column (Optional): Enter a positive numeric value for the color of the box.
- Rows: Each row represents a different item in a category.
Examples
College majors
| Majors | 55 | |
|---|---|---|
| Bachelor of Arts | Majors | 5 |
| English | Bachelor of Arts | 5 |
| History | Bachelor of Arts | 5 |
| Music | Bachelor of Arts | 5 |
| Philosophy | Bachelor of Arts | 5 |
| Bachelor of Sciences | Majors | 6 |
| Math | Bachelor of Sciences | 6 |
| Physics | Bachelor of Sciences | 6 |
| Biology | Bachelor of Sciences | 6 |
| Engineering | Bachelor of Sciences | 6 |
Lunch menu
| Meals | 71 | |
|---|---|---|
| Appetizers | Meals | 20 |
| Soup ($6) | Appetizers | 4 |
| Cheese ($4) | Appetizers | 4 |
| Entrees | Meals | 30 |
| Burger ($8) | Entrees | 9 |
| Pasta ($8) | Entrees | 9 |
| Pizza ($8) | Entrees | 9 |
| Deserts | Meals | 20 |
| Cake ($6) | Deserts | 7 |
| Pie ($6) | Deserts | 7 |
| Drinks | Meals | 6 |
| Water ($2) | Drinks | 2 |
| Tea ($3) | Drinks | 2 |
| Coffee ($3) | Drinks | 2 |
Customize a tree map chart
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Choose an option:
- Chart style: Change the background color and font type.
- Tree map: Change the font style, add min or max values, or change box colors.
- Chart & axis titles: Edit or format title text.