Getting vertices from the edge list

Apr 17, 2012 at 6:33 PM


I input some of my vertices before I input all of my edges.  I now would like to get the vertices from my edge list, however, when I go to prepare data and click on "Get vertices from edge list" no additional vertices are put into the vertices worksheet.  Could you please tell me what I am doing wrong?

Thanks so much!



Apr 18, 2012 at 1:04 AM
Edited Apr 18, 2012 at 1:06 AM


One possibility is that you put your edges in the wrong place.  They have to go in the Excel table on the Edges worksheet.  The Excel table can be distinguished from the rest of the worksheet by the colored cell backgrounds starting in the Color column.  Are your edges part of the table, or are they below the table?  If you can't seem to make your edges part of the table, please see 'What to do if NodeXL's tables don't "auto-expand"' at

If that doesn't fix the problem, please post a troublesome workbook on the Issue Tracker tab at and I'll see if I can figure out what's wrong.  Just create a new "Issue" and attach your workbook to it.  You don't have to explain anything; I'll know what it is.

-- Tony

Apr 18, 2012 at 1:08 AM

Another thing: You're sure that your edges contain vertices that you haven't already entered on the Vertices worksheet, right?  Get Vertices from Edges Worksheet won't copy vertices to the Vertices worksheet if they're already there.

-- Tony