G
Greg
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
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