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
Sub SetWeightsNormal()
Dim srs As series
For Each srs In ActiveChart.SeriesCollection
srs.Format.Line.Weight = 2#
Next
End Sub