Hi Srinivasan, Thanks for your reply. Below is data from the first 6 weeks. Please notice I have a total of 8 players on my team but can only play 5 each week. That means every week I have 3 players who will not play on any given week:
Date_Played, Name, Win_Loss_Record 9/13/2010, L Simms, W 9/13/2010, J Feiman, W 9/13/2010, C Wagner, W 9/13/2010, T Spears, W 9/13/2010, M Simms, L 9/20/2010, D Sachs, W 9/20/2010, C Wagner, L 9/20/2010, J Feiman, L 9/20/2010, L Simms, W 9/20/2010, G Mouning, L 9/27/2010, C Wagner, L 9/27/2010, L Simms, W 9/27/2010, T Spears, W 9/27/2010, J Feiman, L 9/27/2010, G Mouning, L 10/04/2010, D Sachs, L 10/04/2010, M Simms, L 10/04/2010, L Simms, W 10/04/2010, J Feiman, W 10/04/2010, T Spears, L 10/11/2010, T Spears, L 10/11/2010, J Feiman, W 10/11/2010, D Sachs, L 10/11/2010, M Simms, W 10/11/2010, M Pini, L 10/18/2010, T Spears, W 10/18/2010, C Wagner, W 10/18/2010, L Simms, L 10/18/2010, M Simms, L 10/18/2010, G Mouning, W Regards, Greg On Fri, Nov 12, 2010 at 10:31 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > sample data pks > > > On Sat, Nov 13, 2010 at 2:08 AM, Greg <gamoun...@gmail.com> wrote: > >> Hi, >> >> I am a newbie to Excel and think I have a simple request but do not >> know how to get started. I would like to request help in generating >> progress reports for team mates on my "in house league" 8-ball pool >> team. I have been keeping a tally for the past 9 weeks of each persons >> wins and losses. >> >> I want a pie chart to illustrate their contribution to the team for >> the past 9 weeks. For example, I would like to see a percentage based >> on the total number of wins for each person. This percentage is >> displayed as percent/piece of the pie. >> >> Next, I would like to show a bar graph or line chart (like the stock >> market charts) for each individual illustrating their win/loss records >> from week 1 up through week 9. >> >> BTW, please include instructions on how best to enter my data in the >> Excel spreadsheet. I'm told this may need a pivot table but I know >> nothing about how to create them. >> >> Thanks in advance for any assistance you can provide. >> >> Kind regards, >> Greg >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > Srinivasan Ethirajalu, > +919840544295 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
