Tree map charts

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.

Tree map 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

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. 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.

Related articles

Was this helpful?
How can we improve it?