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