This function generates a tree of input data.
AXCEL.VIZ.TREE(data, [title], [deployment])
The AXCEL.VIZ.TREE function syntax has the following arguments:
data Required. data must have minimum two columns. The columns define the hierarchies of the tree from left to right:
title Optional. By default, Axcel tries to find the title from your data such as the name of the first column. Otherwise, you can explicitly define the title of your graph.
deployment Optional. It is the deployment in project/name or owner/project/name format. You need to create a project by logging into your console (https://console.axcel.io) -> Project -> Create Project. After that you can use the project name in your deployment. Please note project and visualization names contain small letters and numbers only. If a project is shared with you, you should use the username of the owner in your deployment. Please visit visualization projects and sharing to learn more about this powerful feature.
when you type =AXCEL.VIZ.TREE in an Excel cell, the IntelliSense guides you through required and optional (shown in  brackets) inputs. Here is an example.
We use a subset of Species extracted from AdeelK93/collapsibleTree GitHub repo. This subset is available in Axcel dataset which you can pull by running this command in Cell A1:
The dataset looks like below:
|Eastern||Softwood||Longleaf and slash pines|
|Eastern||Softwood||Loblolly and shortleaf pines|
|Eastern||Softwood||Other yellow pines|
|Eastern||Softwood||Eastern white and red pines|
We can visualize this hierarchy by running:
And, here is the output:
The graph is an interactive tree. By clicking on each node, it expands the tree which provides a clear and traceable of hierarchies for each column of data.
See also Visualization Projects and Sharing