You need to use an old-style XLM command for this, as Stephen Bullen
pointed out in his post 14-Jan-2001:
Sub WhichPoint()
Dim sPoint As String
Dim iSeries As Integer, iPoint As Integer
sPoint = ExecuteExcel4Macro("SELECTION()")
If sPoint Like "S*P*" Then
iSeries = Val(Mid$(sPoint, 2))
iPoint = Val(Mid$(sPoint, Len(iSeries) + 2))
MsgBox "Series " & iSeries & ", Point " & iPoint
Else
MsgBox "Please select a single data point."
End If
End Sub
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Schlupp wrote:
Hi,
I need help. I must get the index of a the currently selectd point in
the chart. I can't use the Mouseup event.
It will be better to determinate the x and y value from the actual
selected point but the index will also be good.
Please help!
thx
Jens