Organisation Charts
Organisation charts show hierarchical structure with a single root. They can't, unfortunately, be used for family trees because they can only have one root, and the branches cannot merge.
| Query Requirements |
Column 1: Text - name Column 2: Text - manager Column 3: Text - (optional) tooltip The query must return at least the first two columns, the third is optional. For the topmost node, the manager column should be an empty string. |
| Multiple Plots | No |
| Axis Overrides | No |
| Data Formatting | No |
| Extra Columns |
No The tooltip column is optional but no extra column needs to be defined. |
The "Cell Object" syntax can be used to provide formatting for the names. In the example above, the first node name is defined as {v:'Mike', f:'Mike<div style="color:red; font-style:italic">President</div>'}.
If you use HTML in the formatted name or in the tooltip you must specify the extra option ",allowHtml:true".