I have a graphing problem that know one seems to have an answer for. I have 200 bowlers that report their scores to me weekly. I put their scores in Excel. I have about 6 months of weekly scores shown on one screen broken down by single weeks. If I am trying to display short term score change graphicaly. What are some goods ways of doing this so anyone could look at the one page of data with all 200 people's names and quickly tell me, which players are showing a significant short term change in scores.
Meaning if Charly normaly scores around 50 and for 2 weeks he scores a 125 for each week. How can I view this graphically with 200 names at the same time and easily show Charly's significant change in score?
The charts I have seen and I do not like: heat maps, and line graphs. Too much information for this. If their is a program that would do this I will buy it!
Please Help!!
Edited by ar3582 - 06 Jun 2007 at 4:13pm
IP Logged