Hi Ayush, That's perfect! Exactly what I want.
Thanks, Greg On Thu, Jan 20, 2011 at 9:55 PM, Ayush Jain <jainayus...@gmail.com> wrote: > Hi Greg, > > See attached updated one. > I hope it helps. > > > Thanks. > > Best Regards, > Ayush Jain > > On Thu, Jan 20, 2011 at 11:07 PM, Greg Mouning <gamoun...@gmail.com>wrote: > >> 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 >>> >>> >> > > > -- > 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
