Forum Discussion
Chart multiple series formatting
I have 150 individual series in a line chart and am looking for a method to format the line color and outline to be the same for each series as a whole without selecting each series individually to f...
If you're on the desktop version of Excel for Windows or Mac, you could run a macro. Select the chart before doing so.
Sub FormatSeries()
Dim ser As Series
Application.ScreenUpdating = False
For Each ser In ActiveChart.SeriesCollection
With ser.Format.Line
.ForeColor.RGB = vbRed
.Weight = 4
End With
Next ser
Application.ScreenUpdating = True
End Sub