how to change chart line colors in vba 6.0?

[Elainaz]

Does anyone know how to hange chart line colors in vba 6.0?
I tried the way vba 7.0 uses to change them, but it fails.
I can't update its version or install an updated excel cos it's my company's pc and they forbid any new app installation.

 

[Repush]

record a macro on the vb6 machine and you will know . .
from my archives: SeriesCollection(1).Border.ColorIndex and then a number
but I'm not sure it is vb6

 

[NdNoviceHlp]

Maybe this...

With Sheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1).Border
.ColorIndex = 1
'.Weight = xlMedium
'.LineStyle = xlContinuous
End With

HTH. Dave