Feb 15, 2011 at 7:56 AM
Edited Feb 15, 2011 at 5:03 PM
I'm sorry you ran into a problem you couldn't resolve. If anyone else runs into the same problem, here is one way to add labels to vertices in NodeXL:
1. Use Windows Start Menu, All Programs, Microsoft NodeXL, NodeXL Excel Template to create a new NodeXL workbook.
2. Enter an edge list in the Edges worksheet. As an extremely simple example, enter "A" in the Vertex 1 column and "B" in the Vertex 2 column.
3. In the Excel ribbon, click NodeXL, Graph, Show Graph. This shows the graph in the graph pane on the right side of the Excel window and also adds each of the graph's vertices to the Vertices worksheet.
4. Switch to the Vertices worksheet. (You do that with the set of tabs at the lower-left corner of the Excel window.) It has two rows, one for each vertex.
5. Go to NodeXL, Show/Hide, Workbook Columns and make sure that Labels is checked.
6. Fill in the Label column on the Vertices worksheet.
7. Click NodeXL, Graph, Refresh Graph. The graph in the graph pane should now have labels.
8. If the graph doesn't have labels, go to NodeXL, Show/Hide, Graph Elements and make sure that Vertex Labels is checked.
There is an advanced technique called Autofill Columns that Marc mentioned, but that's just an automated way to do what was done manually in the steps I've outlined here.