Chart Series Selected Index

[balumail75]

Hi All,

How to get the selected series index number of a chart?

Thanks for the help,

Rgds,
Balumail75.

[p45cal]

two ways you can check out and test:

Sub dlah()
    If TypeName(Selection) = "Series" Then
        Set ch = ActiveChart.SeriesCollection
        For I = 1 To ch.Count
            If ch(I).Name = Selection.Name Then MsgBox "index is " & I
        Next I
        ' also:
        aa = Selection.Formula
        bb = Mid(aa, InStrRev(aa, ",") + 1)
        MsgBox "also, index is " & Left(bb, Len(bb) - 1)
    End If
End Sub