Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

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. 

 

Anchor
data-sheet
data-sheet

 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

...

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

...

Customization Options

Table of Contents
minLevel5

Go to Customize Your Chart Common Customization Options for more optionssettings.

Font family

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

  • Click the colored square to choose a color for the text in the chart
    • the ColorPicker tool will appear
  • Click a color
    • The text will turn that color, as a preview
  • Click Ok

Font family: sets the font style for the text in your chart

  • Type a font style name into the textbox
  • Note that it's best to use a standard font, such as Ariel or Times New Roman, to ensure that the font will appear the same way across different devices

Header color: sets the color of the header text for each node

  • Click the colored square
    • the ColorPicker tool will appear
  • Either: Click a color
  • Or: Click No color
    • the rectangle below the sliders will remain blank and your headers will be white
  • Click Ok
    • The headers will appear in the color you chose

Header height: sets the height of the header section for each node

  • Type a number into the textbox
    • Note that this number can be zero

Header highlight color: sets the color a text header will be when a user hovers over it

  • Click the colored square
    • The ColorPicker tool will appear
  • Either: click a color
  • Or: Click No color
    • The rectangle below the sliders will remain white, and a header will not turn a different color 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

on your chart

  • Type the name of the font family in the field
  • Use web-safe fonts: these fonts are installed on most browsers
  • Web-safe fonts include Arial, Arial Black, Courier New, Tahoma, Times New Roman, Verdana, and others 
Header color

sets the color of the header text for each node

  • Click the colored square to choose your color
  • Learn more about choosing colors
Header height

sets the height of the header section for each node

  • Type in a number
  • "0" makes the header invisible
Header highlight color

sets the color of text headers when you hover over them

  • Click the colored square to choose your color
  • Learn more about choosing colors
Anchor
maximum-color
maximum-color
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.

  • Click the colored square to choose your color
  • Learn more about choosing colors
Maximum color value

sets the highest values for your chart's color scale

  • Type in a value (numeric) 
  • Nodes with values greater or equal to this number have the maximum color
  • Set node values in column 4 of the data spreadsheet
Max levels

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

  • Type in a number
  • For example, if you don't want to show any child nodes, type in 1, and if you want to show root nodes plus one child node, type in 2
  • Note that if your tree has more levels than this number, the viewer will need to click the visible nodes to see additional levels
Max levels to hint at

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

  • Type in a number
Maximum highlight color

sets the highlighting color of the largest node

  • Click the colored square to choose your color
  • Learn more about choosing colors
Middle color

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

  • Click the colored square to choose your color
  • Learn more about choosing colors
Middle color value

determines the section of nodes that appear in the middle color

  • Type in a number
  • Note that nodes with values below that number will not 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

  • Click the colored square to choose your color
  • Learn more about choosing colors
Minimum color

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

  • Click the colored square to choose your color
  • Learn more about choosing colors
Minimum color value

determines the least intense color that appears in your chart

  • Click the colored square to choose your color
  • Learn more about choosing colors
Minimum highlight color

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

  • Click the colored square to choose your color
  • Learn more about choosing colors
No value color

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

  • Click the colored square to choose your color
  • Learn more about choosing colors
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.

  • All values greater than this will be trimmed to this value
  •  If set to null or "auto," the value will be set to the max value in the column
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

  • Click the colored square to choose your color
  • Learn more about choosing colors
Show tooltips?

displays a text tooltip when you hover over a node

  • "True" shows tooltips
  • "False" hides tooltips

 

 

 spreadsheet, you can choose a color here to set the scale by the which the rest of the colors are generated