Spreadsheet Format
You can build organization charts from tree data structures. Tree data structures are hierarchical: each node (or element on the tree) has a parent node. In the example below, each box represents a node. "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 Organization Chart data spreadsheet represents a node on the tree.
| Column 1 | Column 2 | |
|---|---|---|
| Data Type | plain text | plain text |
| Contents | The name of the node. Each node must have a unique name. | The name of the node's parent. Note:
|
For the sample tree above, the spreadsheet might look like this:
| Node | Parent |
|---|---|
| Pet | null |
| Cat | Pet |
| Dog | Pet |
| Rabbit | Pet |
| Domestic Shorthair | Cat |
| Siamese | Cat |
| Corgi | Dog |
| Great Dane | Dog |
| Labrador | Dog |