XYChart interactive points/markers
Posted on 2011-10-02
I have an XYChart with only 30 points plotted on it.I want by using an auto run macro to be able to click on point/marker then a message box will pop up showing the series name or the x and Y valuesor even a value from a cell i define or to do any other event.
I tries to use the below command in my macro but no use.
if Worksheets(2).ChartObjects(1).Chart.SeriesCollection(1).Points(1).Selection = True then ....