thanks simon.
I agree it probably would be easier in access and I might try that. I would
like to distribute the reports and excel would be easier. I am also much
better in excel than in access. I was planning on using a form in excel to
capture the game data and then use pivot tables and predefined reports to
report the game and player data. My biggest hangup was the shot chart. I
will give it a shot. I am still interested in how other people would
approach the problem.
thanks,
rob
"smw226 via OfficeKB.com" wrote:
Hi Mr. Rodgers,
If you have the skills and time I think this is possible although I think
Access would be easier.
- My thoughts are to use your scatter idea as plotting on a graph is simply
marks the place where X and Y values meet.
I would use an entry form to record game, date, player, team, shot position
etc. and store this in a table.(see why I meantioned access!)
Then use another form for the selection criteria you want to plot and update
the graph source data with VBA.
I have tried this on a 10x10 grid and it seems to work fine. Shot positions
are stored as x y co-ordinates which are picked by the scatter and plotted eg:
Player x_pos y_pos
1 9 7
1 8 6
2 5 3 .......
If none of this makes sense please let me know and I will try to explain
further but, again, this would be an awfull lot easier in access.
HTH
Simon
Mr. Rodgers wrote:
I would like to develop a soccer scorebook spreadsheet and I would like to
keep track of player and team shot charts. A soccer shot chart is a picture
of a soccer field and then I would put a O or X on the field to make the
place were a player took a shot. I want the shot chart to update when I
select different players or show all shots when I select the team. can this
be done in excel? Will using a chart (scatter plt) work. i would also like
to record all the shots in a certain section of the field by player. the are
many software program you can purchase that do this, but I would liek to
create my own in excel. I am a very advance user of Excel and I am
comfortable coding in VB. I just can seem to think of how to create shot
charts similar to a basketball game shot chart.
--
--------------------
Simon - UK
Email at simon22mports [ a t ] hot mail [ d ot ]com
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200704/1