bsaisu
asked on
interact with point's label
Guys,
The attached xls file has a macro which enables me to do an action when i click on any point/marker on the xychart. What i want now is to do the same this for the label in which if i click on it ,it will do the same action that is assigned when i click on the point/marker. Usually when someone clicks on the label, the text in it will be highlighted to enable you to edit it, so I don't know how we can come over this.
chartevents3.xls
The attached xls file has a macro which enables me to do an action when i click on any point/marker on the xychart. What i want now is to do the same this for the label in which if i click on it ,it will do the same action that is assigned when i click on the point/marker. Usually when someone clicks on the label, the text in it will be highlighted to enable you to edit it, so I don't know how we can come over this.
chartevents3.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
rorya, your solution is good but in your solution I have to click on the point or the label twice to trigger the event. andrewssd3 has fixed this