A self-loop is created when a vertex links to itself.
Self-loops appear as circles in NodeXL network visualizations.
The display of self-loops can be controlled via the “Visibility” column in the Edges worksheet.
To reveal the “Visibility” column select the menu item:
To reveal the “Visibility” column select the menu item:
NodeXL Pro>Show/Hide>Workbook Columns>Visual Properties
In the Edges worksheet, each edge has a “Visibility” column.
In the “Visibility” column you can place a formula that checks if Vertex1 = Vertex2. If so, the formula places a “0” (Zero) in the cell. If not, the formula places a “1”.
“0” (Zero) = “Skip” (which acts as if the data has been deleted).
The Excel formula is:
=IF([@[Vertex 1]]=[@[Vertex 2]],0,1)
Then Refresh the graph and the self -loops should no longer be displayed!