Plot points on a chart and record the coordinates

[Guest]

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

 

[Jon Peltier]

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