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.
See also Visualization Projects and Sharing