Chart multiple series formatting

Question

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 format

hansvogelaar · Answer

Duane7247&nbsp;
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

Forum Discussion

Chart multiple series formatting

1 Reply

Resources