Example

Spreadsheet Format

Tree data structures are hierarchical. Each node has a parent nodes.  In the example below, "Pet" is the parent of "Cat," "Dog," and "Rabbit". "Cat" is the parent of "Domestic Shorthair" and "Siamese." "Pet" is also the root note, since it has no parent.

Example of tree data structure.

 

 

 

 

 

 

 

 

 

 

Each row in the Tree Map data spreadsheet represents a node on the tree. 

 

 Column 1Column 2Column 3Column 4
Data Typeplain textplain textnumbernumber
Contents

The name of the node.

The name of the node's parent.

Note:

  • If this is the first node on the tree (called the root), leave this cell blank
  • This name must match the entry in the first column of the row that defines the parent node

A value for the node.

Note:

  • This determines the size of the node relative to the other nodes.

A second value for the node.

Note:

  • This determines the color of the node relative to the other nodes.
Optional   x

 

For the sample tree above, the first two columns might look like this: 

NodeParent
Pet 
CatPet
DogPet
RabbitPet
Domestic ShorthairCat
SiameseCat
CorgiDog
Great DaneDog
LabradorDog

Customization Options

Go to Common Customization Options for more settings.

Font family

sets the font for the text on your chart

Header color

sets the color of the header text for each node

Header height

sets the height of the header section for each node

Header highlight color

sets the color of text headers when you hover over them

Maximum color

this is the color represented by the number in the fourth column of your spreadsheet. If you did not choose a value in this column of the spreadsheet, you can choose a color here to set the scale by the which the rest of the colors are generated.

Maximum color value

sets the highest values for your chart's color scale

Max levels

sets the number of node levels you want your chart to show at the same time

Max levels to hint at

shows the number of node levels beyond the maximum level that a user can view

Maximum highlight color

sets the highlighting color of the largest node

Middle color

sets the color for the node halfway between the largest and the smallest

Middle color value

determines the section of nodes that appear in the middle color

Middle highlight color

sets the highlighting color for the node with a column 3 value that falls between the maximum color value and the minimum color value in your spreadsheet. The highlight will be a color between the maximum color value and the minimum color value

Minimum color

sets the color of the node(s) representing the smallest column 4 values

Minimum color value

determines the least intense color that appears in your chart

Minimum highlight color

sets the highlighting color for the node with a column 3 value that is nearest the minimum color value

No value color

sets the color of nodes without a value in the third column of the spreadsheet.

No value color value

sets the color of nodes that were not given a specific color in the third column of the spreadsheet. Sets the value to use for a rectangle of 'no' color when highlighted.

No value highlight color

highlights areas of the chart without values 

choose to have sections of the chart with no color be highlighted in a color when you hover the mouse over them

Show tooltips?

displays a text tooltip when you hover over a node