LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to label last point for selected series only EricBB Excel Discussion (Misc queries) 1 January 22nd 09 10:56 AM
Can I link comments on the chart to a point on the chart? RL Charts and Charting in Excel 1 October 11th 07 10:03 AM
HELP need index of the actual selected point Schlupp Charts and Charting in Excel 4 August 11th 05 06:56 AM
Detect if a selected cell is within a named range CraigB Excel Programming 2 November 25th 04 03:44 PM
chart point value Claude Excel Programming 5 June 5th 04 07:00 PM


All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"