NETWORK

You are here:

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 APoint 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:

StartEnd
Factory1Warehouse1
Factory1Warehouse2
Factory1Warehouse3
Factory2Warehouse2
Factory2Warehouse3
Factory2Warehouse4
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