How do I change the series name by using Excel VBA 1

[xitu]

This is one part the code to make the series:


.SeriesCollection.XValues = rngClock
.SeriesCollection.Values = rngDiffTemp

My chart will display Series1, Series2, Series3 ...


If I add this line

.SeriesCollection.Name = "Test"


My chart will display Test, Test, Test ...

How do I change Test, Test, Test, ... to Test1, Test2, Test3, ... ?

Thanks for your help.

 

[SkipVought]

Would this work?

 .SeriesCollection(n).Name = "Test" & n

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xitu]

Excellent. Thanks Skip.