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 Customize Your Chart for more options.

Font color: sets the font color for the text in your chart

Font family: sets the font style for the text in 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 a text header will be when a user hovers over it

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