Load Network Graph

Load Network Graph#

The Load Network Graph tool allows you to visualize network data stored in Google Sheets or Excel files located within your project.

Data Requirements#

To generate a graph, your data source must contain specific columns.

Required Columns#

  • Node ID: A unique identifier for the node.

  • Edge Start & Edge End: Node IDs defining the connection (edge) between two nodes.

Note

A network loaded with only these three columns will have its layout determined automatically by a network layout algorithm.

Optional Columns#

You can customize the visualization using the following additional columns:

  • Node X / Node Y: Explicit coordinates to specify where to place each node.

  • Node Size: Determines the size of individual nodes.

  • Node Color: Determines the color of nodes.

  • Edge Color: Determines the color of edges.

  • Edge Dashed: Determines if an edge should be displayed as a dashed or solid line.

Display Features#

Use the following controls to toggle display options:

  • Show Edges (Yes/No): Show or hide edges.

  • Show Edge Color (Yes/No): Show custom edge colors or revert to the default color.

  • Show Node Size (Yes/No): Show variable node sizes or revert to the default uniform size.

  • Show Node Color (Yes/No): Show variable node colors or revert to the default uniform color.

Filters#

You can filter and style the graph based on specific value ranges:

Node Color by Value Range

Select a value range to apply colors to matching nodes. Additionally, you can choose to show only matching nodes or hide all matching nodes.

Edge Color By Value Range

Select a value range to apply colors to matching edges.

Node Size by Value Range

Select a value range to apply sizes to matching nodes. Additionally, you can choose to show only matching nodes or hide all matching nodes.

Configuration#

To load your data:

  1. Navigate to Data Source Configuration at the bottom of the tool’s control bar.

  2. Select your Google Sheet or Excel file.

  3. Choose the specific Sheet containing the data.

  4. Select or unselect specific columns to configure the graph loading.

Contents