Spreadsheet Format
You can build organization charts from tree data structures. Here's a representation of a tree data structure:
...
Each row in the Organization Chart spreadsheet represents a node on the tree. Learn more about spreadsheets in Visuals at Use Spreadsheet Data.
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:
|
Required | x | x |
For the sample tree above, the spreadsheet 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 |
Customization Options
These options are exclusive to organization charts. Go to Common Customization Options for Charts and Graphs for more options for more settings.
Node size
determines the size of nodes size: determines how large the nodes should be on your chart
- choose "large," "medium," or "small"
Allow HTML in nodes?
: sets HTML in your nodes to active or inactive
- "True" makes it active
- "False" makes it inactive
Allow node collapse?
: controls whether or not a node collapses when a user clicks it, hiding every node below it
...