Greg, You are most welcome cheers
On Fri, Jan 21, 2011 at 9:05 PM, Greg Mouning <gamoun...@gmail.com> wrote: > 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 >> >> > -- 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