Hi
I have a line chart with three series on it. Can vba change the marker style of all three lines at once? Or will I have to loop through using 'For Each'?
If the only answer is 'For Each' then please could I get some guidance on how to do this with SeriesCollection 1-3.
Many thanks![]()
Dim AnnualChart As Object Set AnnualChart = ActiveSheet.Shapes("AnnualChart").Chart If ActiveSheet.Range("A11").Value2 = "January" AnnualChart.SeriesCollection(1).MarkerStyle = xlMarkerStyleSquare End If
James
Bookmarks