The Def(Property) property specifies the default value assigned to a particular property when a new series is created. It does not affect any existing series; instead, it only applies to series added after the default is defined. This property is especially useful when you need to add multiple series that share common settings. For example, if you plan to create several series that all use the same chart type, color, or stacking group, you can define these defaults once through the Def property. Every subsequent call to add a new series will automatically inherit those predefined values. After all required series are created, you can reset or change the default values as needed before adding others.

For instance, the following sample sets a common value for Stack and ShowValue properties:

With .Series
    .Def(exSerieStack) = "A"
    .Def(exSerieShowValue) = 1
    .Add("3").Color = RGB(91,148,201)
    .Add("5").Color = RGB(238,127,48)
    .Add("2").Color = RGB(167,167,167)
End With