Retrieve point address from scatter plot by clicking?
 

Basically, I'm trying to retrieve several selects peaks and troughs from an
oscillation data set with multiple amplitudes. It would be optimal to click
on the point and transfer the coordinate values to the spreadsheet.

You need to trap chart events, then determine where the click occurred
and which point was under it. I discuss chart events in this article:

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

A section entitled "Identify the Point Clicked By the User" is located
about halfway through the article.

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


Jdoggrr wrote:

Basically, I'm trying to retrieve several selects peaks and troughs from an
oscillation data set with multiple amplitudes. It would be optimal to click
on the point and transfer the coordinate values to the spreadsheet.

Retrieve point address from scatter plot by clicking?
 

Hi Jon,
Over the past month, I have gone through your code, and have tried modifying
it to suit my needs. However, because I am a VBA nepohyte, I am unable to get
the code to work when I transfer to my own sheet. Would it be possible to
email the sheet to you, so you could take a look at it?

Thanks
Justin

"Jon Peltier" wrote:

You need to trap chart events, then determine where the click occurred
and which point was under it. I discuss chart events in this article:

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

A section entitled "Identify the Point Clicked By the User" is located
about halfway through the article.

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


Jdoggrr wrote:

Basically, I'm trying to retrieve several selects peaks and troughs from an
oscillation data set with multiple amplitudes. It would be optimal to click
on the point and transfer the coordinate values to the spreadsheet.

Retrieve point address from scatter plot by clicking?
 

Thanks for asking first. I can't promise an immediate response, but I
will try to look at it in a few days. Make the obvious correction to my
email address.

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


Jdoggrr wrote:

Hi Jon,
Over the past month, I have gone through your code, and have tried modifying
it to suit my needs. However, because I am a VBA nepohyte, I am unable to get
the code to work when I transfer to my own sheet. Would it be possible to
email the sheet to you, so you could take a look at it?

Thanks
Justin

"Jon Peltier" wrote:


You need to trap chart events, then determine where the click occurred
and which point was under it. I discuss chart events in this article:

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

A section entitled "Identify the Point Clicked By the User" is located
about halfway through the article.

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


Jdoggrr wrote:


Basically, I'm trying to retrieve several selects peaks and troughs from an
oscillation data set with multiple amplitudes. It would be optimal to click
on the point and transfer the coordinate values to the spreadsheet.