Graphics Reference
In-Depth Information
Figure 11-15:
Using symbols to express topic and color to express
sentiment provides a high-level picture of the subject and mood of
community chatter. Here, red and black indicate estimated positive and
negative comments about Raptor players, indicated by their jersey
numbers, and team ambassador Drake, indicated with a musical note.
In the Topic Symbols Calc column, add a formula to the fan rows that
concatenates the symbols of any topic mentioned, separated by spaces:
=CONCATENATE(IF(AP4,CONCATENATE(AP$1,"
"),""),IF(AQ4,CONCATENATE(AQ$1,"
"),""),IF(AR4,CONCATENATE(AR$1,"
"),""),IF(AS4,CONCATENATE(AS$1,"
