Graphics Reference
In-Depth Information
Figure 11-12:
Search for references to names and record matches.
Summarize subject by single match, no match (“other”), or multiple
matches (“mixed”).
Now, create a formula in a new column to the right of the mention columns
that notes the single subject matched, “other” if none matched, or “mixed” if
multiple subjects were matched:
=IF(SUM(AK3:AP3)>1,"mixed",IF(AK3=1,AK$2,IF(AL3=1,AL$2,IF(AM3=1,AM$2,
IF(AN3=1,AN$2,IF(AO3=1,AO$2,IF(AP3=1,AP$2,"other")))))))
As a final step, copy the values of the new columns into the graph data area
oftheworksheetusingthePasteValuesoption.Youshouldseeaheaderwith
a drop-down arrow appear above the new graph data column, similar to the
others. Give the mention columns and the topic column meaningful names,
and export the enhanced graph in GraphML format for import into Gephi.
When you import, ensure that you uncheck the auto size option to preserve
your original node sizes.
Map node color to topic using the Partition tab. Modify the random default
color assignments to make them intuitive. The players are one family of
topics, so choose colors from the same family. Blues and greens might be an
appropriate choice for players, in which case, a distinctly different color like
red might be a good choice for Drake. Neutral middle gray, a colorless color,
is a logical choice for “other” topics, and “mixed” topics might naturally
be represented by neutral-but-salient colors like white or black. Switch to
Preview taskmode,reapplyedgeopacityof20percent,andrefreshtheview.
