Jun 1, 2010 at 11:04 PM
Edited Jun 2, 2010 at 12:23 AM
I believe you are describing several problems here. Let's start by addressing the first one.
When you say "I can filter out all edges but those representing 'policy and instruction' core document citations," you didn't say how you were doing the filtering. I'll assume that you were using Excel's table-filtering feature on the Vertices
worksheet -- that is, the down-arrows within the column headers. That won't work, as you've discovered. Filtering out a vertex that way won't prevent it from showing in the graph. The following technique
will work, however.
If your graph has a subset of vertices S, and you want to show only those vertices and the edges that connect them, then do the following:
1. For each vertex in S, set its Visibility cell on the Vertices worksheet to Show if in an Edge.
2. For all other vertices, set their Visibility to Skip.
When a vertex's Visibility is Skip, NodeXL skips the vertex's row and any edge rows that use the vertex, which will give you the behavior I think you want. The Skip option and all other Visibility options are explained in the popup message
that appears when you hover your mouse over the Visibility column header.
Given the size of your graph, I'm sure you don't want to fill in the Visibility cells by hand, and that's where Excel's formulas come in handy. You can enter a formula in the first cell of the Visibility column that computes the Visibility based on
other column values, and Excel will automatically fill the column with your formula. I suggest looking at the IF() function, which can output either "Show if in an Edge" or "Skip", depending on a condition you specify. (Outputting
1 and 0 will do the same thing.)
Does that get you started, or did I misunderstand your post?