+ Reply to Thread
Results 1 to 2 of 2

Creating a chart that summarizes top five results from data set

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    1

    Creating a chart that summarizes top five results from data set

    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

  2. #2
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Re: Creating a chart that summarizes top five results from data set

    Kels - what I would do is post the spreadsheet you have, good or bad, so I can see what you have. Based on what you have above, I am having an issue envisioning your spreadsheet, but that is me!!! I have an idea or two but do want to see what you have..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1