Using Dynamic Filters

NodeXL lets you filter the graph's edges and vertices based on numeric and date/time attribute values. For example, you can filter the graph so that only vertices with Degree between 0 and 2 are visible in the Graph Pane. You specify the filters with a set of sliding range bars, and as you adjust the range bars, the filtered edges and vertices disappear immediately from the Graph Pane. They are still contained in the graph, but they are hidden.

Dynamic filtering is different from Excel's built-in filter features. (Excel's built-in features include the Data, Sort & Filter, Filter item in the Ribbon, and the down-arrow menus in the column headers.) If you filter out edges or vertices using Excel filtering, the filtered edges and vertices are completely ignored by NodeXL and never become a part of the graph. NodeXL's dynamic filters, on the other hand, hide the filtered vertices and edges but do not remove them from the graph.

The Dynamic Filters dialog box has one filter for each numeric and date/time column in the Edges and Vertices worksheets. Each filter spans the range of values contained in its respective column, and a histogram shows you the value distribution over the range.

By default, NodeXL always shows edges and vertices that have empty cells in a column. For example, if you are filtering on the Degree column on the Vertices worksheet and some vertices have an empty Degree cell, those vertices will be shown in the Graph Pane regardless of your Degree filter settings. See To specify how empty cells are handled for information on changing this behavior.

If you refresh the graph while the Dynamic Filters dialog box is open, the dynamic filters remain applied to the Graph Pane. If you close the Dynamic Filters dialog box and refresh the graph, the dynamic filters are removed. You can apply them again by opening the Dynamic Filters dialog box again.

To dynamically filter the graph's vertices and edges:
  1. In the Excel Ribbon, select NodeXL, Analysis, Dynamic Filters.
  2. In the Dynamic Filters dialog box, adjust the filters for the edge and vertex attributes you want to filter on. See the sections below for details on how adjustments can be made.
To adjust the lower end of a dynamic filter's range, do one of the following:
To adjust the upper end of a dynamic filter's range, do one of the following:
To shift the dynamic filter's range to the left or right, do one of the following:
To specify how empty cells are handled:
To adjust the opacity of the dynamically filtered vertices and edges:

More Information