Default chart font color and size

[joyousrob]

Hi guys,

I'm looking for a way to change the default font (Calibri to Arial) and color (gray to black) as well as font size (8 to 10). On all old and/or new graphs I make on excel.

I have been scouring online and haven't found a way to change the graphs defaults, the only way I have found how to do this is through macros, am I wrong? is there a way to change the default graphs? Have to make a lot of them and don't want to change each one individually.

Macros I have found look something like the one below but don't fully accomplish what I want, and in the case of the one below are not working.

Sub DL()


Dim chSeries As Series

For Each chSeries In Charts(1).SeriesCollection
With chSeries.DataLabels.Font
.Name = "Arial"

.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 50
.Background = xlAutomatic
End With
Next


End Sub


Any help is most welcome

THANKS!