How to use VLOOKUP for the distinction of shape at bi-partite network

Sep 5, 2013 at 8:42 AM
Hello! I have a problem using VLOOKUP for changing the shape and colour of two kinds of vertices! I have made a different worksheet named categories and put there as indicated the column I want and the two types of vertices, next column is shape, and then colour. What should I put in the first row, the second and the third? Should the worksheet "Vertices" be classified with ascending series according to the column of the vertex type?

Sorry for my questions but I am kind of confused with the way i can distinguish and understand in a clear way bi-partite networks.

Last question (I hope): is there any way to group by cluster without changing the shape of the vertices since I will have already changed that for the distinguish of the two kinds of vertices? Thanks a lot for your help in advance!
Sep 5, 2013 at 4:51 PM
Concerning your last question, do this:
  1. Select NodeXL, Analysis, Groups, Group Options.
  2. In the Group Options dialog box, under the "What shapes should be used for the groups' vertices?" question, select "The shapes specified in the Shape column on the Vertices worksheet."
-- Tony
Sep 5, 2013 at 5:12 PM
Edited Sep 5, 2013 at 5:13 PM
Concerning your first question:

If I understand what you're saying, you have two types of vertices and you want each type to have a certain shape/color combination.

I don't think you need an additional worksheet or a VLOOKUP to accomplish that. Try this:

1) Add a "Type" column to the Vertices worksheet and enter one of your two types for each vertex. I'll call the types "Student" and "Teacher" in my example here. (You probably already have such a column.)

2) Enter the following formula into the first empty cell in the Shape column on the Vertices worksheet:

=IF(Vertices[[#This Row],[Type]]="Student", "Circle", "Square")

That formula says "if this vertex has a Type of Student, set the Shape to Circle; otherwise set it to Square.

3) Similarly, enter this formula into the first empty cell in the Color column on the Vertices worksheet:

=IF(Vertices[[#This Row],[Type]]="Student", "Orange", "Purple")

You will need to change "Circle", "Square", "Orange" and "Purple" to your preferred shapes and colors, of course.

-- Tony