Hi Ayush, Awesome job! The pie chart displays the contents I requested.
However, I question the win/loss percentage. It should total 100% and currently it totals 155%... I believe the total loss percentage = 55% is accurate as we had a losing session. That would mean the total win percentage should calculate to 45%. This would means the win percentage for each player should be smaller as well. Can you verify this? Regards, Greg On Thu, Jan 20, 2011 at 12:03 PM, Ayush Jain <jainayus...@gmail.com> wrote: > Hi Greg, > > I have modified the Pie chart as required by you. > Please see attached file and let me know for any further assistance > required. > > Best Regards, > Ayush Jain > Group Manager and Microsoft MVP > > > >>>> On Wed, Jan 12, 2011 at 12:02 PM, ayush jain <jainayus...@gmail.com>wrote: >>>> >>>>> Hi Greg, >>>>> Due to some office work, i have not responded you on this...I hope to >>>>> get back to you by this weekend on this... >>>>> >>>>> >>>>> BR, >>>>> Ayush Jain >>>>> >>>>> >>>>> On Wed, Jan 12, 2011 at 7:09 AM, Greg Mouning <gamoun...@gmail.com>wrote: >>>>> >>>>>> Dear Ayush, >>>>>> >>>>>> Thank you the graphs you generated look awesome! I love the bar chart >>>>>> particularly as it demonstrates our team progress over 16 weeks. >>>>>> >>>>>> As for the pie chart, I am not sure that it represents what I am >>>>>> looking to report. I guess first, I want a pie chart that shows 9 slices. >>>>>> Because there are 16 weeks of data and I can only play 5 out of 8 players >>>>>> each week; the total number of weeks (16) multiplied by (5) matches >>>>>> equal 80 >>>>>> total matches. I think it needs to use all 80 games and create a >>>>>> percentage >>>>>> of each persons wins which demonstrates their individual contribution. >>>>>> This >>>>>> percentage, should should make up 8 slices of the pie, one for each >>>>>> player. >>>>>> Finally, there needs to be (1) remaining slice to represent the >>>>>> remainder of >>>>>> the pie which is the total matches loss. >>>>>> >>>>>> If there is a way to add the win/loss records of individual players, >>>>>> that would be perfect. For example, in my case I played 11 matches, so it >>>>>> needs to display the following data inside of my slice of the pie: >>>>>> >>>>>> >>>>>> G Mouning >>>>>> 8% >>>>>> (3-8) >>>>>> >>>>>> I don't know if this explanation is any more helpful but I thought I >>>>>> should try to explain what I want differently. Thanks again for your >>>>>> additional assistance. >>>>>> >>>>>> Best regards, >>>>>> Greg >>>>>> >>>>>> >>>>>> On Sun, Jan 9, 2011 at 9:52 AM, ayush jain <jainayus...@gmail.com>wrote: >>>>>> >>>>>>> Hi Greg, >>>>>>> >>>>>>> Please see if the charts created in attached Excel workbook helps >>>>>>> you. >>>>>>> Feel free to write back if you need any further assistance. >>>>>>> >>>>>>> Thanks. >>>>>>> >>>>>>> Best Regards, >>>>>>> Ayush Jain >>>>>>> Group Manager & Microsoft MVP. >>>>>>> >>>>>>> >>>>>>> On Sun, Jan 9, 2011 at 9:53 AM, Greg <gamoun...@gmail.com> wrote: >>>>>>> >>>>>>>> Hello, >>>>>>>> >>>>>>>> Happy New Year! It has been a couple of months and I have not >>>>>>>> received >>>>>>>> an answer to a request I made. I would like to know how to generate >>>>>>>> Pie Charts and Bar Graphs based on data in an Excel spreadsheet. If >>>>>>>> it >>>>>>>> is helpful, I have made my Excel Spreadsheet called, >>>>>>>> "Fall_Session_Data.xls" available at the following weblink: >>>>>>>> >>>>>>>> http://db.tt/Ynfa44I >>>>>>>> >>>>>>>> Thanks in advance for your assistance. >>>>>>>> >>>>>>>> -Greg >>>>>>>> >>>>>>>> On Nov 12 2010, 3:38 pm, 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/discussexcel >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Best regards, >>>>>>> Ayush Jain >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Best regards, >>>>> Ayush Jain >>>>> >>>>> >>>> >>> >>> >>> -- >>> Best regards, >>> Ayush Jain >>> >>> >> > > > > -- > Best regards, > Ayush Jain > > -- ---------------------------------------------------------------------------------- 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/discussexcel
