Creating Groups by Vertex Attribute

You can tell NodeXL to create groups using the values in a column on the Vertices worksheet. For example, if your vertices represent people and you have a "Country" column on the Vertices worksheet, NodeXL can create a group for each country. Or if you have a "Salary" column that contains numbers, NodeXL can create a group for each salary range that you specify. Groups can also be created using a column that contains dates, times, or dates with times.

To remove any existing groups and create new groups based on a vertex attribute:
  1. In the Excel Ribbon, select NodeXL, Analysis, Groups, Group by Vertex Attribute.
  2. In the Group by Vertex Attribute dialog box, select the column that contains the vertex attribute values.
  3. Specify whether the vertex attribute values are categories (such as "Country" in the above example), numbers, dates, times, or dates with times.
  4. If the vertex attribute values are numbers, dates, times, or dates with times, specify the group value ranges.
  5. Click OK.
  6. Show the graph to see the groups.

Note that some vertices might be left "ungrouped." If a cell in the vertex attribute column is empty, or its value doesn't fall within one of the ranges you specify, the vertex will not be put into a group.


More Information