Graphics Reference
In-Depth Information
column corresponding to the same row as the formula, the column
reference is prefixed with a
@
—for example,
=[@MyData]
. For example,
in the graph in
Figure 7-8
,
note the following:
• Node size is set to the sum of
In-Degree
and
Out-Degree
, as
shown here:
=[@In-Degree]+[@Out-Degree]
• Node label is set to the Twitter name if the node size is large, as
shown here:
=IF([@Size]>8,[@Vertex],"")
Tip
NodeXL's templates are set up as Excel Tables and can use Column
References in formulas.
•
Column Filters
—Every data attribute can be used as a filter using
Excel's column filter drop-down menus. For example, social network
data may result in many small nodes or nodes without any edges. Use
the drop-downs to remove all the nodes without edges, as shown in