Circle graph: vertices by color then size

Aug 7, 2014 at 8:25 PM
I am creating a network graph to measure interactions between different departments at our company. I'd like to create a circle graph that arranges the vertices by color (which is their department) and then by size (largest to smallest, the size is the in-degree).

The only way I see to organize vertices in a circle graph is by in-degree, which looks great, but I want it to be organized by color. Any ideas? Thanks!
Aug 8, 2014 at 5:02 AM
Yes, you can do that. First you sort the vertices by color and size, and then you tell NodeXL to arrange the vertices around the circle using that sort order.

Follow these steps:

1) If you haven't already done so, use NodeXL, Visual Properties, Autofill Columns to fill the Size column based on In-Degree. I assume that both Color and Size are filled in at this point.

2) Select any data cell on the Vertices worksheet, then use Data, Sort & Filter, Sort to sort the vertices by the Color column, and then by the Size column. (You use the "Add Level" button in the Sort dialog box to specify a "Sort by...Then by..." order.)

3) Now that your Vertices worksheet is sorted properly, go to NodeXL, Show/Hide, Workbook Columns and check "Layout" in the drop-down menu. That will make a column called "Layout Order" visible on the Vertices worksheet.

4) In the first data cell of the "Layout Order" column, enter the following, without the quotes: "=ROW()". That will fill each Layout Order cell with its row number.

5) Refresh the graph. You're done.

-- Tony