Feb 2, 2012 at 1:14 AM
Edited Feb 2, 2012 at 1:16 AM
There are a couple of ways I can think of to get NodeXL to ignore the Vertex Color column on the Groups worksheet:
1. The deliberate way. If you go to NodeXL, Analysis, Groups, Group Options and select "the color specified in the Color column on the Vertices worksheet" as an answer to the "What color should be used for the groups' vertices" question, then NodeXL
will ignore the Vertex Color column on the Groups worksheet. But I believe you already verified that you haven't done this.
2. The accidental way. If you overwrite a column header on the Groups worksheet (if you overwrite "Vertex Color" with "Garbage," for example), then NodeXL will just ignore the Groups worksheet. However, there will then be no indication at all
in the graph pane that the graph has any groups. I assume that you are seeing some indication in the graph pane that the graph has groups?
There may be other accidental ways as well.
This is difficult to diagnose without having the workbook, which I know you can't share with us due to confidentiality requirements. Perhaps you could try exporting your graph to a new NodeXL workbook to see if that fixes the problem. You can
do that like so:
1. Right-click the graph pane and select Select All, Vertices and Edges from the right-click menu. (Or click anywhere in the graph pane and type Ctrl-A.)
2. In the ribbon, select NodeXL, Data, Export, Selection to New NodeXL Workbook.
3. Recreate your groups in the new workbook using one of the "Group by" items on the NodeXL, Analysis, Groups menu. (The groups don't get exported.)