Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to label last point for selected series only | Excel Discussion (Misc queries) | |||
Can I link comments on the chart to a point on the chart? | Charts and Charting in Excel | |||
HELP need index of the actual selected point | Charts and Charting in Excel | |||
Detect if a selected cell is within a named range | Excel Programming | |||
chart point value | Excel Programming |