PDA

View Full Version : Chart Series Selected Index



balumail75
08-27-2012, 03:26 AM
Hi All,

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

Thanks for the help,

Rgds,
Balumail75.

p45cal
09-24-2012, 07:42 AM
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