Plot points on a chart and record the coordinates
 

I want to work a scatter plot chart in reverse, whereby click on the chart to
select a point and then have the chart record the x,y coordinates? Is this
possible in Excel? I want to create a shot chart for soccer/basketball and
want to be able to record shots by player and then recall them when I select
different players. I can get it to work by suppling the x,y coordinates, but
I want it to give me the x,y coordinates when i slect a point on the graph
instead.

Thanks

Plot points on a chart and record the coordinates
 

You'll need to use chart events to detect a click, then go through some
algebra to determine where to put the point, since the position of the click
is in different coordinates than the axis location of the marker. Here's a
tutorial about chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mr. Rodgers" wrote in message
...
I want to work a scatter plot chart in reverse, whereby click on the chart
to
select a point and then have the chart record the x,y coordinates? Is
this
possible in Excel? I want to create a shot chart for soccer/basketball
and
want to be able to record shots by player and then recall them when I
select
different players. I can get it to work by suppling the x,y coordinates,
but
I want it to give me the x,y coordinates when i slect a point on the graph
instead.

Thanks