Display Dual Labels at Same Time

Jul 17, 2013 at 11:02 PM
Edited Jul 17, 2013 at 11:03 PM
How can one display both the vertice name & it's corresponding pagerank score at the same time in a circle graph?
  • Note, the use case is for analyzing website traffic, whereby the edge pairs are previous/current content pages
Jul 18, 2013 at 12:48 AM
Edited Jul 18, 2013 at 12:48 AM
I assume that you have already calculated PageRank using NodeXL, Graph Metrics, and so your Vertices worksheet now has a PageRank column.

Try this:

1 Select the Vertices worksheet using the tabs at the lower-left corner of the Excel window.

2 Make sure you can see the Label column on the Vertices worksheet. If it's not there, use NodeXL, Show/Hide, Workbook Columns, Labels to make it visible.

3 Select the entire Label column.

4 Right-click the selected Label column, select Format cells from the right-click menu, and change the column's Number Category to General. This is important; the formula in the next step won't work if the column is left at its default Category of Text.

5 In the first cell of the Label column, which is H3 in recent versions of NodeXL, enter this formula:

=Vertices[[#This Row],[Vertex]] & " " & Vertices[[#This Row],[PageRank]]

Now, when you show the graph, the labels will look like "John 0.781232", for example.

-- Tony