Tree map charts

Employ a tree map when you desire to show a data tree, where objects are organized into parent-child hierarchies. For example, show the average annual sales of each detail in a product category.

Larn how to add together & edit a chart.

Tree map chart

How to format your data

  • First column: Enter the proper noun of an object in your hierarchy.
  • Second column: Enter the name of the object's parent. The parent proper name must likewise 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 3rd column.
  • Fourth column (Optional): Enter a positive numeric value for the color of the box.
  • Rows: Each row represents a unlike particular in a category.

Examples

College majors

Majors 55
Available of Arts Majors 5
English Bachelor of Arts five
History Available of Arts five
Music Bachelor of Arts 5
Philosophy Bachelor of Arts 5
Bachelor of Sciences Majors 6
Math Bachelor of Sciences six
Physics Bachelor of Sciences 6
Biology Bachelor of Sciences half dozen
Engineering Bachelor of Sciences half-dozen

Tree map chart showing college majors

Brand a copy

Lunch menu

Meals 71
Appetizers Meals 20
Soup ($six) Appetizers 4
Cheese ($4) Appetizers 4
Entrees Meals 30
Burger ($8) Entrees 9
Pasta ($eight) Entrees 9
Pizza ($8) Entrees 9
Deserts Meals twenty
Cake ($6) Deserts 7
Pie ($half-dozen) Deserts 7
Drinks Meals half-dozen
Water ($2) Drinks 2
Tea ($3) Drinks 2
Coffee ($3) Drinks ii

Tree map chart showing lunch menu

Make a copy

Customize a tree map nautical chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you desire to alter.
  3. At the right, click Customize.
  4. Choose an selection:
    • Chart fashion: 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

  • Types of charts & graphs in Google Sheets
  • Add together & edit a chart or graph
  • Organizational chart

Was this helpful?

How can we ameliorate it?