Frequency Graph with Multiple values

Discussion in 'Excel Charting' started by frankjh19701, Oct 28, 2013.

  1. frankjh19701

    frankjh19701 Guest

    I have a sales team spreadsheet that shows which sales person worke
    with whom. Everyone has to partner with someone at least once during th
    week.

    What I want to find out is who is working with who and how frequentl
    they are working with the same partner.

    My goal is to have solid number like:

    Smith worked with Baker 3 times
    Baker worked with Tilly 4 times
    and so on.

    I have attached a sample spreadsheet as well.

    Please let me know if anyone has any ideas.

    Thank yo

    +-------------------------------------------------------------------
    |Filename: Sample Worksheet 2.zip
    |Download: http://www.excelbanter.com/attachment.php?attachmentid=926
    +-------------------------------------------------------------------


    --
    frankjh19701
     
    frankjh19701, Oct 28, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. jeanne
    Replies:
    1
    Views:
    197
    Mike Middleton
    Jan 13, 2004
  2. Chen G
    Replies:
    2
    Views:
    228
    Chen G
    Nov 1, 2004
  3. johnnyrover
    Replies:
    1
    Views:
    114
    Tushar Mehta
    Aug 27, 2005
  4. gziomek
    Replies:
    3
    Views:
    72
    gziomek
    Dec 28, 2005
  5. Sanjay Kumar Singh
    Replies:
    1
    Views:
    350
    Tushar Mehta
    Jan 3, 2006
  6. ted
    Replies:
    2
    Views:
    113
    Jon Peltier
    May 4, 2006
  7. Leo Bueno
    Replies:
    1
    Views:
    177
    Andy Pope
    Aug 2, 2007
  8. side-by-side relative frequency bar grap

    side-by-side relative frequency bar graph

    side-by-side relative frequency bar grap, Sep 19, 2007, in forum: Excel Charting
    Replies:
    1
    Views:
    264
    Jon Peltier
    Sep 19, 2007
Loading...