Versions Compared

Old Version 8

changes.mady.by.user Veronica Kuhn

Saved on

compared with

New Version Current

changes.mady.by.user Veronica Kuhn

Saved on

Key

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

Spreadsheet Format

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

...

You place nodes on the tree using two values: the name of the node, and the name of the node's parent.  This is the only relationship that matters when you're building your spreadsheet. For example, you can place the Labrador node by knowing only with "Labrador" (it's name) and "Dog" (it's parent). Remember, any node on the tree can be a parent. 

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 spreadsheet represents a node on the tree.  Learn more about spreadsheets in Visuals at Use Spreadsheet Data.

 

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

The word "node"

Note:

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

name of the node. Each node must have a unique name.

The name of the node's parent.

Note:

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

The number of branches that extend from the node

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

 

 

For the sample tree above, the spreadsheet might look like this: 

 NodeBranchesnode3nodePet0
NodeParent
Pet 
CatPet
rootDogPet
RabbitPetPet
Domestic ShorthairCat
2SiamesenodeCat
CorgiDog3
nodePetRabbit0
nodeCatDomestic Shorthair0
nodeCatSiamese0
nodeDogCorgi0
nodeDogGreat Dane0
nodeDogLabrador
Great DaneDog
LabradorDog

 

Customization Options

These options are exclusive to organization charts. Go to Common Customization Options for more settings. 

Node size

determines the size of nodes 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

  • "True" makes nodes collapsible
  • "False" keeps nodes stationary