I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, Batman, Cyclops", but I can change it if needed.
Is there a way to use the plot/chart tool to create a graph which shows the frequency of each collaborator (essentially a histogram, perhaps sorted by frequency)?
In case a graphical representation is not possible, a textual representation will do, e.g., a sorted list of all collaborators, with the number of collaborations next to each person's name.
I'll be very glad to hear any ideas!