Spreadsheet Format

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

Example of tree data structure.

 

 

 

 

 

 

 

 

 

Tree data structures are made of nodes, or elements on the tree. In the example above, each box represents a node.

Tree data structures are also hierarchical: each node (or element on the tree) has a parent node. In the example above, "Pet" is the parent of "Cat," "Dog," and "Rabbit". "Cat" is the parent of "Domestic Shorthair" and "Siamese."

Trees have a root node, which has no parent. "Pet" in the example above is the root node, since it has no parent. 

You place nodes on the tree using two values: the name of the node, and the name of the node's parent. For example, you can place the Labrador node by knowing only "Labrador" (it's name) and "Dog" (it's parent). Remember, any node on the tree can be a parent. 

leaf is a node that isn't a parent (that is, it has no children). In the example above, "Domestic Shorthair", "Siamese", "Corgi", "Great Dane", "Rabbit", and "Labrador" are all leaf nodes. 

Each row in the Tree spreadsheet represents a node on the tree. 

 

 Column 1Column 2Column 3
Data Typeplain textplain textplain text
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
  • Parents determine the bubble's color

The name of the node

Note:

  • Only leaf nodes will be labeled on the bubble visualization

 

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

 ParentNode
noderootPet

node

PetCat
nodePetDog
nodePetRabbit
nodeCatDomestic Shorthair
nodeCatSiamese
nodeDogCorgi
nodeDogGreat Dane
nodeDogLabrador

 

Customization Options

Bubble style: choose how you want to display the bubbles your graph

Bubble spacing: decide how far apart to keep the bubbles from each other

Group color: note that this property only applies to bubble graphs whose style is set to "packed." Choose the color of the circles enclosing the packed bubbles.

Node color: note that this property only applies to bubble graphs whose style is set to "packed." Choose what color you want the nodes to be.