Spreadsheet Format
You can build organization charts from tree Tree graphs from tree data structures. Here's a representation of a tree data structure:
Tree data structures are made of nodes, or elements on the tree. In the example above, each box represents a node.
...
A branch is a connection between two nodes. For example, there are two branches that extend from "Cat," and three that extend from "Pet."
Each row in the Organization Chart the Tree spreadsheet represents a node on the tree.
| Column 1 | Column 2 | Column 3 | Column 4 | |
|---|---|---|---|---|
| Data Type | plain text | plain text | plain text | number |
| Contents | The word "node" Note:
| The name of the node's parent Note:
| The name of the node | The number of branches that extend from the node
|
For the sample tree above, the spreadsheet might look like this:
| Parent | Node | Branches | |
|---|---|---|---|
| node | root | Pet | 3 |
node | Pet | Cat | 2 |
| node | Pet | Dog | 3 |
| node | Pet | Rabbit | 0 |
| node | Cat | Domestic Shorthair | 0 |
| node | Cat | Siamese | 0 |
| node | Dog | Corgi | 0 |
| node | Dog | Great Dane | 0 |
| node | Dog | Labrador | 0 |
Customization Options
Go to Common Customization Options to see more 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
- Your viewer can see hidden branches by clicking on the respective node