There are five worksheets built into a NodeXL workbook. With a simple graph, the Edges worksheet may be the only one you work with. The other worksheets offer customization options for more advanced scenarios.
The following table describes the NodeXL worksheets.
Worksheet | Description |
---|---|
Edges |
Contains the graph's edges, which you specify as Vertex 1/Vertex 2 name pairs, along with optional edge attributes. The vertex name pairs are the only columns in the entire workbook that are required. |
Vertices |
Contains the graph's vertices, along with optional vertex attributes. When you show the graph, NodeXL automatically creates a row in this worksheet for each vertex in the Edges worksheet. The only vertices you have to enter manually are isolated vertices that are not connected to edges. (You must set the Visibility cell for an isolated vertex to Show to get the vertex to show up in the Graph Pane.) If your graph has no isolated vertices and you do not want to customize any vertices, you can ignore the Vertices worksheet. |
Groups |
Contains the names of the graph's groups, along with the groups' attributes. See Understanding the Group Worksheets for more information. If your graph does not have groups, you can ignore the Groups worksheet. |
Group Vertices |
Contains the names of the vertices in each of the graph's groups. See Understanding the Group Worksheets for more information. You can usually ignore the Group Vertices worksheet, even if your graph has groups. |
Overall Metrics |
Contains the graph's overall metrics, which you can calculate on demand. See Calculating Graph Metrics for more information. If you do not calculate graph metrics, you can ignore the Overall Metrics worksheet. |
If you calculate group metrics, a Group Edges worksheet gets added to the workbook. This worksheet lists the number of edges within each group and the number of edges between group pairs.
You may want to add columns to a worksheet or add a new worksheet to the workbook to hold your own data.