Series reference on a chart
 

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

--
kev_0
-----------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...fo&userid=3504
View this thread: http://www.excelforum.com/showthread.php?threadid=56389

Series reference on a chart
 

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