Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2007

Tip: Looking for answers? Try searching our database.

Plot points on a chart and record the coordinates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mr. Rodgers - 30 Apr 2007 16:50 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.