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 - 30 Apr 2007 18:39 GMT
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
_______
>I want to work a scatter plot chart in reverse, whereby click on the chart
>to
[quoted text clipped - 10 lines]
>
> Thanks