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
Tree map chart showing college majors

Make a copy

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
Tree map chart showing lunch menu

Make a copy

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

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
15660463430155789719
true
Search Help Center
true
true
true
true
true
35
false
false