Tree Map

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 1

Column 2

Column 3

Column 4

Data Type

plain text

number

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:

Node	Parent
Pet
Cat	Pet
Dog	Pet
Rabbit	Pet
Domestic Shorthair	Cat
Siamese	Cat
Corgi	Dog
Great Dane	Dog
Labrador	Dog

Page tree

Customization Options