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.
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 | plain text | number | number |
Contents | The name of the node. | The name of the node's parent. Note:
| A value for the node. Note:
| A second value for the node. Note:
|
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 |
Go to Common Customization Options for more settings.
sets the font for the text on your chart
sets the color of the header text for each node
sets the height of the header section for each node
sets the color of text headers when you hover over them
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.
sets the highest values for your chart's color scale
sets the number of node levels you want your chart to show at the same time
shows the number of node levels beyond the maximum level that a user can view
sets the highlighting color of the largest node
sets the color for the node halfway between the largest and the smallest
determines the section of nodes that appear in the middle 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
sets the color of the node(s) representing the smallest column 4 values
determines the least intense color that appears in your chart
sets the highlighting color for the node with a column 3 value that is nearest the minimum color value
sets the color of nodes without a value in the third column of the spreadsheet.
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.
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
displays a text tooltip when you hover over a node