How do I graph/chart this information in a way that tells the whole story?
February 10, 2010 4:10 AM Subscribe
I need to graph/chart the information below, but I am not sure what format tells the whole story. Can you help?
posted by laskagirl to Work & Money (10 answers total) 1 user marked this as a favorite
My company has a lot of meetings with foreign nationals. Various suboffices within the company and occasionally the head of the company conduct these meetings with varying numbers of foreign associates. We want to graph/chart/visually capture this activity in a way that shows:
* What offices in our company are conducting the meetings
* WHEN they are conducting them (I'd like to have either the x or y axis be the months of the year, so we can see our annual coverage)
I can do a regular graph in PowerPoint that includes the numbers of foreign nationals met with and categorizes our internal agencies by color. OK.
But here's what I can't seem to capture: The numbers or frequency of some offices' meetings don't really tell the whole story. The head of the company's meetings are clearly more significant than the others. He might have just one meeting with just one foreign partner, but that meeting can be more significant for our company than countless weekly working meetings some other section has.
Final information: The reasons we are making this chart are 1) to capture what we do to see where our coverage is and where we may have gaps 2) to prioritize our resources.
So, graphic information specialists and other Mefites, what do you think? How can I meaningfully display this data in one graph?