+ Reply to Thread
Results 1 to 3 of 3

Compare Player vs others in a good way

  1. #1
    Registered User
    Join Date
    07-26-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    6

    Compare Player vs others in a good way

    I have a table where every player received some scores for some days.

    For internal use, I can now plot a pivot table and compare a player to everyone else, but my goal is to show a graphic to each player how he/she is doing against ALL OTHERS combined (as average).

    Do i really have to do a pivot chart for every player separately as I did now or can I put everything in one diagram and then just filter which of them I want to show? This would be of course more efficient, since I have lots of years/months and I dont want to change every chart individually.

    I hope you understand my issue; my English is not maternal language.

    At the moment you see how I did it (but I want the two graphs on the left in 1 graph: Jason vs others (2 bars per month), Sarah vs others (2 bars per month) and so on


    I hope you can help me
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-26-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    6

    Re: Compare Player vs others in a good way

    I tried with grouping but I can only group one...
    so Jason vs all others
    but then I dont know how to make a 2nd group where I exclude Peter for example

  3. #3
    Registered User
    Join Date
    07-26-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    6

    Re: Compare Player vs others in a good way

    no answer = no solution?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Player Rotation
    By Lethal29 in forum Excel General
    Replies: 0
    Last Post: 03-13-2016, 08:38 PM
  2. Player Rank Calculation
    By filfilha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2014, 12:13 PM
  3. [SOLVED] Top scores w/ corresponding player, also with a tie
    By madman1734 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 11:40 AM
  4. Replies: 6
    Last Post: 02-25-2009, 02:12 AM
  5. Media Player versus Windows Media Player
    By teepee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2005, 02:05 PM
  6. [SOLVED] Media Player versus Windows Media Player
    By teepee in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 10:05 PM
  7. Media Player versus Windows Media Player
    By teepee in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 10:05 PM

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