Add Method (Charts Collection)

See Also         Example         Applies To

Creates a new chart sheet. Returns a Chart object.

Syntax

expression.Add(Before, After, Count)

expression   Required. An expression that returns a Charts object.

Before   Optional Variant. An object that specifies the sheet before which the new sheet is added.

After   Optional Variant. An object that specifies the sheet after which the new sheet is added.

Count   Optional Variant. The number of sheets to be added. The default value is one.

Remarks

If Before and After are both omitted, the new chart is inserted before the active sheet.