SOLVED Drawing Arrow to Max Value on Chart

[MT_Shanachie]

I have a line chart for which the underlying data is updated by users' selections.

I want to indicate the maximum value for each of four data series using VBA. I am able to identify the maximum value, and currently I am applying a datalabel to show the maximum.

I'd prefer to show the maximums using arrows rather than lablels if this is possible. I know I can draw a line using the Shapes.AddLine(BeginX, BeginY, EndX, EndY) syntax. Is there a way to identify the X and Y coordinates of the maximum value in the data series?

Thanks.
This message was edited by MT_Shanachie on 2002-11-01 15:38

 

[MT_Shanachie]

Problem solved. Thanks to Andrew Poulsom for his method in this thread:

http://216.92.17.166/board/viewtopic.php?topic=23147&forum=2