Forum Discussion
Duane7247
Nov 10, 2023Copper Contributor
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 format
1 Reply
Sort By
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