Return series point data value

Hello all. I am using chart events to highlight a series collection in a chart when the the mouse is clicked on a legend entry (courtesy of Peltiertech.com). In addition to highlighting the series I am also trying to find the maximum value in the highlighted series and add a label or highlight that point. I am a novice so I really just hope and poke around until I get it right. I am having problems returning the y axis value of a data point and was hoping someone could nudge me in the right direction. I have tried the following with many variations:

Please Login or Register  to view this content.

As you presumably know the range of the source data, you should be able to deduce which row in this range is linked to the point in question based upon its index number.

This will return the maximum value.

Please Login or Register  to view this content.

this will loop through the values

Please Login or Register  to view this content.