Macro for formatting lines on a line chart

[FinUser]

Hi all, I have a macro in excel that sets all the line weights in an active chart to a specific line width. The code is below. However, as well as changing any line on a line graph (what I want), on mixed graphs it also adds a border to column or area charts, which is something I don't want! Any ideas on how I adjust the code to only change lines on series that are line charts but not any other chart type? Thank you!

Sub SetWeightsNormal()
Dim srs As series
For Each srs In ActiveChart.SeriesCollection
srs.Format.Line.Weight = 2#
Next
End Sub

 

[Domenic]

You can check for a line chart using the ChartType property of the Chart object...

Sub SetWeightsNormal()

    Dim srs As Series
    
    If ActiveChart.ChartType = xlLine Then
        For Each srs In ActiveChart.SeriesCollection
            srs.Format.Line.Weight = 2#
        Next
    End If
    
End Sub

Hope this helps!