Versions Compared

Key

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

Spreadsheet Format

You can build Tree graphs from tree data structures. Here's a representation of a tree data structure: 

...

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

The word "node"

Note:

  • Enter the word "node" in the first cell for every row

The name of the node's parent

Note:

  • If this is the first node on the tree (called the root), write "root" in the cell
  • Keep node names consistent across the spreadsheet
The name of the node

The number of branches that extend from the node

  • In the example above, Column 4 for the "Cat" node would be 2.

 

...

 ParentNodeBranches
noderootPet3

node

PetCat2
nodePetDog3
nodePetRabbit0
nodeCatDomestic Shorthair0
nodeCatSiamese0
nodeDogCorgi0
nodeDogGreat Dane0
nodeDogLabrador0

 

Customization Options

Go to Common Customization Options for Charts and Graphs to see the rest of the optionsmore settings 

Transition time

: determines the time it takes for a branch to expand or collapse

  • Type in a larger number for a longer amount of time
  • Type in a smaller number for a shorter amount of time
Branch spacing

: determines how far apart to space the branches

  • Type in a higher number to increase the space between branches
  • Type in a smaller number to lessen the space between branches
Branch levels to show

: controls the number of branches to show at once

  • Type in a number; 0 shows all branches
  • Note that a user Your viewer can see hidden branches by clicking on the respective node

...