NETWORK

AXCEL.VIZ.NETWORK function

This function generates network visualization of input data.

Syntax

AXCEL.VIZ.NETWORK(data, [title], [deployment])

The AXCEL.VIZ.NETWORK function syntax has the following arguments:

data Required. data must have two columns. The first column describes the “from” and the second column is “to”.

from	to
Point A	Point B
Point A	Point C
…	…
…	…
…	…

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.NETWORK in an Excel cell, the IntelliSense guides you through required and optional (shown in [] brackets) inputs. Here is an example.

Example:

ACME has multiple factories and warehouses. The products flow between these facilities is presented in this table which is located at A1:B9:

Start	End
Factory1	Warehouse1
Factory1	Warehouse2
Factory1	Warehouse3
Factory2	Warehouse2
Factory2	Warehouse3
Factory2	Warehouse4
Warehouse4	Warehouse1
Warehouse4	Warehouse5

By running this function, we can visualize this network:

=AXCEL.VIZ.NETWORK(A1:B9, “ACME Warehouses”)

And, here is the output:

THis graph is interactive and user can relocate the nodes to customize the view.