Versions Compared

Key

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

Spreadsheet Format

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

...

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

 

 Column 1Column 2Column 3
Data
Type
Typesplain 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

Go to Common Customization Options for more settings

Anchor
style
style
Bubble style

choose how you want to display the bubbles your graph

  • "Grouped": the bubbles are grouped in a circular shape, with smaller bubbles dispersed among the larger ones
  • "Spiral": the bubbles are in a spiral shape, from largest to smallest
  • "Packed": the bubbles are grouped within different concentric circles, according to their relationships
Bubble spacing 

decide how far apart to keep the bubbles from each other

  • If you decided to style the bubbles as "Packed," this option will have no effect

  • Type in a higher number to space bubbles farther apart, or type in a smaller number to space bubbles closer together
Group color

this property only applies to bubble graphs with "packed" style. Choose the color of the circles enclosing the packed bubbles.

Node color

choose the color of the nodes. This property only applies to bubble graphs with a "packed" style.