Weird line chart VBA problem

[Siyanna]

Hi

I have a simple code where I change the line chart type to dotted - I have 4 lines of data (4 series)

When I step through the code - the lines specified change to dash but for some reason when I run the code in 1 go - it changes my line to a normal line

is this a bug?

I am using excel 2013

Here is the code snippet I am running - my charts are named Chart01 - Chart02 etc

I have even put DoEvents but that don't work either

Dim i As Long

For i = 1 To 5
Worksheets("DailyView2").ChartObjects("Chart0" & i).Activate
With ActiveChart
.SeriesCollection(3).Format.Line.DashStyle = msoLineSysDot
.SeriesCollection(3).Border.Color = RGB(128, 128, 128)
.SeriesCollection(3).Format.Line.Weight = 1.5
.SeriesCollection(4).Format.Line.DashStyle = msoLineSysDot
.SeriesCollection(4).Border.Color = RGB(0, 0, 0)
.SeriesCollection(4).Format.Line.Weight = 1.5
End With
Next i

 

[mole999]

fiddle with the order they are processed


.SeriesCollection(4).Border.Color = RGB(0, 0, 0)
.SeriesCollection(4).Format.Line.Weight = 1.5
.SeriesCollection(4).Format.Line.DashStyle = msoLineSysDot

sometimes one application changes the next

 

[Siyanna]

Thank you - I will try and s to if that makes any difference