Hello everyone-I've been stumped for a few days now and could use some expert help. I am attempting to create either a bar chart or a line graph for top five call center issues, and how many calls were received over a quarter, from data that was accumulated over the month. The excel sheet has hidden columns that show the weekly data, and the columns month to month are lined up next to one another. I've tried summing the data, etc, but I need it to be able to change with the data as more numbers are added in over a period of time. Here is an example of the data. I can't figure out how to even begin with this. Any help would be much appreciated.
October 2012 November 2012 December 2012
Issue Number of Calls Issue Number of Calls Issue Number of Calls
Question about 16 Question about 24 Insuring dependents 85
insurance insurance
General Requests 14 Error Reporting 22 General Requests 53
Insuring Dependents 10 Refunds 19 Question about insurance 47
Reporting 8 Additional Expenses 16 Refunds 39
Refunds 7 Reporting 13 Error Reporting 32
Bookmarks