MT_Shanachie
New Member
- Joined
- Apr 30, 2002
- Messages
- 48
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
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