Automatically Calculating Visual Properties for All Edges, Vertices or Groups
You can tell NodeXL to automatically calculate one or more visual properties for all the graph's edges, vertices and groups based on the values in other workbook columns. This is called autofilling columns. For example, if you have an Edge Weight column on the Edges worksheet, NodeXL can calculate and set the width of each of the graph's edges based on the edge's weight. Edges with a large Edge Weight will then be thicker than edges with a small Edge Weight.
By default, NodeXL calculates the edge widths, for example, using a linear mapping between the full range of Edge Weight numbers and the full range of available widths, but you can specify various options to change the way NodeXL performs its calculations.
To automatically calculate visual properties:
-
In the Excel Ribbon, select NodeXL, Visual Properties, Autofill Columns.
-
The Autofill Columns dialog box has one row for each worksheet column that can be autofilled. Find the name of the worksheet column you want to autofill, then select the "source column" that contains the values NodeXL should use for the calculations. In the above example, select "Edge Weight" as the source column for the Edge Width column.
-
Repeat step 2 for any additional worksheet columns you want to autofill.
-
Click the Autofill button. The worksheet columns get filled with the calculated values and the graph refreshes automatically. (If it doesn't refresh automatically, check the "Automatically refresh the graph" checkbox in the Graph Options dialog box.)
-
In the Autofill Columns dialog box, click the Options button (
) for the Edge Width worksheet column, for example.
-
Select Edge Width Options from the popup menu.
-
Change the options in the dialog box that appears.
-
In the Autofill Columns dialog box, click the Options button (
) for the Edge Width worksheet column, for example.
-
Select Clear Edge Width Worksheet Column Now from the popup menu.
To clear all worksheet columns that have been autofilled:
-
In the Autofill Columns dialog box, click the Clear All Worksheet Columns Now button.
Here are some things to know about Autofill Columns:
-
If a source column doesn't exist when Autofill is clicked, the corresponding worksheet column does not get autofilled.
-
Autofilling multiple columns in a large workbook can be slow, especially if one of your worksheets is filtered.
More Information