danryan.us

Enter the information from the table above on the edges worksheet.
On the vertices worksheet, copy the vertex names in the first column to the Label column.
Press the Refresh Graph button. The result will almost certainly NOT look like an organizational chart. We'll fix that momentarily.

On the vertices worksheet, select the cell range containing the vertices and adjust their appearance using the buttons on the NodeXL ribbon.
(if you have trouble seeing your vertices and/or labels try setting vertex size to 3.5 and pushing zoom all the way to the left and scale all the way to the right)
Click on the select cursor in the graph window

Drag the vertices one by one until they look something like this:

One layout you might have seen is shown below. The topology (what is connected to what) is the same as above but this layout makes it appear that VP1 is at the middle of the organization — the four people on either side have to go through her and this might make her some sort of "gatekeeper."

But we've left something out. The vertical dimension in a "normal" organizational chart implies a relationship of "gives orders to" or "takes orders from" or "is the supervisor of" or "is the subordinate of." Each of these is an asymmetric relationship and the network (graph) they produce is a directed one (also known as a directed graph or digraph). In NodeXL we can switch the type of the graph in the graph panel of the NodeXL ribbon. To make the lines and arrows easier to see we go to the edges worksheet and then use the edgewidth button in the visual properties panel.

Download the NodeXL file here.