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
Bookmarks