You are here:


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:

Level1 Level2 Leveln
L1-a L2-a

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 ( -> 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
EasternSoftwood Loblolly and shortleaf pines
EasternSoftwoodOther yellow pines
EasternSoftwoodEastern white and red pines
EasternSoftwoodJack pine

We can visualize this hierarchy by running:

=AXCEL.VIZ.TREE(A1#, “Species”)

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