View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Detect selected chart point

I want to detect by code what datapoint in an XY chart is clicked on by the
user, i.e. series collection ID and then data point ID within the series
collection. Additionally, I want to PREVENT the series collection from being
selected as a result of the user click.

What I'm trying to do is to display a XY chart, and when the user selects
any one point, I want to display additional information about that one point.
When the user selects a different point, show the information about that
other point, etc.

I've got a routine that will tell me the X and Y screen coordinates of a
user click, but I'm not looking forward to translating that into chart
coordinates, and then deciphering the data point from the chart coordinates
and I want to know if there is a more direct approach.

Finally, how do I prevent the series collection from being selected as a
result of the click?

Thanks,
-mark