Series reference on a chart

[kev_06]

I'm trying to reference a series on a chart with seriescollection(). How can I find out what the index number of the series is? I've tried using the name of the series, but I can't seem to get it to work.

[Greg Wilson]

Example:

Sub GetChartSeries()
Dim s As Series
Dim cht As Chart
Set cht = ActiveSheet.ChartObjects(1).Chart
Set s = cht.SeriesCollection("Sales Data")
s.Border.ColorIndex = 5
s.Fill.ForeColor.SchemeColor = 5
End Sub

Regards,
Greg

"kev_06" wrote:

>
> I'm trying to reference a series on a chart with seriescollection(). How
> can I find out what the index number of the series is? I've tried using
> the name of the series, but I can't seem to get it to work.
>
>
> --
> kev_06
> ------------------------------------------------------------------------
> kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
> View this thread: http://www.excelforum.com/showthread...hreadid=563898
>
>