Adding additional information to the Vertices sheet

Oct 28, 2008 at 4:19 PM
I want to know how and where to add the additional information into the Vertices sheet.  It is preformatted with specific columns.  Does additional data you wish to add go on columns at the end of the preformatted area or where exactly are they added and how to bring any of that data into the graph?  I understood the Online tutorial for (Excel) .NetMap: October 27, 2008 at Harvard (which I attended) to say you can add additional data and graph it.  Is there a sample Vertices sheet with additional data added to view and how to access.  Thanks.
Oct 28, 2008 at 5:17 PM

You can add columns anywhere in the Vertices worksheet that is convenient for you; the exact location is irrelevant for .NetMap.  To add a column to the right end of the Vertices worksheet, for example, click cell Q1 and type a column name, and Excel will create the column for you.  (Excel likes to copy the attributes of the previous column when you do this, and unfortunately that includes the mouse-hover tooltip from the preceding ID column.  If this bugs you, click cell Q2; select Data, Data Tools, Data Validation, Data Validation in the Excel ribbon; and click Clear All.)  If you want your new column somewhere else, right-click any column and select Insert.

How you fill that new column with data is entirely up to you, but you would typically copy-and-paste it from another Excel workbook or another application.  That's for vertices.  For edges, however, you can import additional edge columns directly from another open workbook using the .NetMap, Graph, Import, From Another Open Workbook ribbon item.  So if you have edge data in some format that can be imported into an Excel workbook (tab-delimited, comma-delimited, etc.), it's easy to get that edge data into a .NetMap workbook, including any additional columns.

Once those additional columns have been added to the Vertices or Edges worksheet, there are several ways to use them.  Let's say your vertices represent people and you've added an Age column to the Vertices worksheet.  You can then go to .NetMap, Graph, AutoFill Columns in the ribbon and specify that you want Vertex Radius to use the values in the Age column.  Now when you click Read Workbook in the graph pane, the largest vertices will represent the oldest people and the smallest vertices the youngest.  Or you can click Dynamic Filters in the graph pane (starting with version, and you'll see a slider control for the Age column.  As you move the slider, the people who fall outside the slider's age range will disappear from the graph.  Or if you're handy with Excel formulas, you can use the Age column as an argument to a formula in another column; for example, you can insert a formula into the Visibility column that will cause only those people who are 5, 10, or 25 years old to be shown.

-- Tony