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.

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

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

i played around with a scatter plot chart and it would work but the problem i
have is that charts work from having the x,y coordinates as a given and then
plot the point. I wan to selevt/place the point on the scatter plot and then
have it record the x,y coordinates. so it works in reverse, i tell the chart
where i want the point plotted and it gives me the x.y coordinates so i can
store them and then recall them again. it's an interesting problem.

"Mr. Rodgers" wrote:

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