Line chart default settings

Question

How do I change the default line style width in a line chart from the fat 2.25 thickness to a more reasonable 1.5 thickness? Templates are not the answer since they set more than the one parameter and need to be applied each time a chart is added or changed. This makes evaluating data by changing the charted data region unusable. I want to change the fundamentaldefault setting.

Answer 1

I'm prettty sure you cannot change the default setting, but the following code changes all the series on the active chart to line thickness of 1.5.

Sub FormatAllSeries()

    Dim SeriesNum As Series

    With ActiveChart

        For Each SeriesNum In.SeriesCollection

            SeriesNum.Format.Line.Weight = 1.5

        Next

    End With

End Sub