Feb 16, 2012 at 6:00 AM
Edited Feb 16, 2012 at 6:01 AM
I'm not sure I understand your latest request, but in reading my previous answer, I realized it was incorrect. It happened to work on the data I tried it on, but it won't work in general. Sorry about that.
Try this instead, and tell me if it gives you what you need:
1. In the Dynamic Filters dialog box, click Reset All so everything is visible again. You won't be using dynamic filters for this.
2. Switch to the Vertices worksheet.
3. Sort the Vertices worksheet by Out-Degree, smallest to largest.
4. For all vertices for which Out-Degree is under the threshold, set the Visibility column to Skip. You can do this manually or use an Excel formula.* With a formula, step 3 isn't required.
5. Refresh the graph. The vertices for which Out-Degree are under the threshold will be gone from the graph pane.
6. Right-click the graph pane and select Select All, Vertices and Edges. (Or click the graph pane and enter Ctrl-A.)
7. Use NodeXL, Data, Export, Selection to New NodeXL Workbook. You'll end up with a new NodeXL workbook that has only those vertices that have Out-Degree greater than the threshold, along with their incident edges.
* Sample formula for a threshold of 1: =IF(Vertices[[#This Row],[Out-Degree]] > 1, "Show if in an Edge", "Skip")