Point-and-Click Graph Tools - Graph Analysis and Visualization - page 228

Figure 7-8: NodeXL is an Excel plug-in with templates you can use to
easily configure the graph. Mouse over any cell for configuration hints.
NodelXL Worksheet
NodeXL provides all the features and flexibility of Excel, such as familiar
toolbars, formulas, and filters. The worksheet templates make it easy to
configure and manipulate the graph. Each column heading includes a brief
comment that indicates how to use the cells in that column. (Point at the
little red comment triangle to see the comment.)
The following are some useful Excel worksheet functionality:
• Formulas —You can set visual attributes using Excel's formulas. You
can use standard Excel formulas such as setting cell F3 to be = R3 +
2 . Since the NodeXL template sets up the graph data in Excel tables,
you can also use Excel column references, which work similar to named
ranges in Excel. For example, if one column is named MyData , then a
formula in another column can be set to reference the initial column by
name—for example, =sum([MyData]) . To reference the data in the