ActiveChart.SeriesCollection(1) exsist ?

[aviadht]

Hi,

I'm writing a code that suppose to give new colors to a graph, how can i check in a ActiveChart.SeriesCollection(1) is exsist or not ?

For example: ActiveChart.SeriesCollection(1) is exsist but ActiveChart.SeriesCollection(5) sometimes is in the graph and sometimes not..

i want the vba to give a new color only if ActiveChart.SeriesCollection(5) is in the graph

Thanks,
Aviad

 

[Jerry Sullivan]

Hi Aviad,

One way to test if a series exists is to check the SeriesCollection.Count

With ActiveChart
    If .SeriesCollection.Count >= 5 Then
       .SeriesCollection(5).Format.Line.ForeColor.RGB = RGB(255, 0, 0)
    End If
End With

 

[Grovnic]

Jerry - many thanx for this - I used part of your code in totaly different case
Regards

Grovnic