Applies To
Charts Collection.
Description
Creates a new chart. Returns a Chart object.
Syntax
object.Add(before, after, count)
object
Required. The Charts object.
before
Optional. Specifies the sheet before which the new sheet is added.
after
Optional. Specifies the sheet after which the new sheet is added.
count
Optional. The number of sheets to add. If omitted, the default is one.
Remarks
If before and after are omitted, the new chart is inserted before the active sheet.
Example
This example creates an empty chart sheet and inserts it before the active sheet.
ActiveWorkbook.Charts.Add