Charts.Add Method
Creates a new chart sheet. Returns a Chart object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Add ( _
Before As Object, _
After As Object, _
Count As Object _
) As Chart
'Usage
Dim instance As Charts
Dim Before As Object
Dim After As Object
Dim Count As Object
Dim returnValue As Chart
returnValue = instance.Add(Before, After, _
Count)
Chart Add(
Object Before,
Object After,
Object Count
)
Parameters
Before
Type: System.ObjectOptional Object. An object that specifies the sheet before which the new sheet is added.
After
Type: System.ObjectOptional Object. An object that specifies the sheet after which the new sheet is added.
Count
Type: System.ObjectOptional Object. The number of sheets to be added. The default value is 1.
Return Value
Type: Microsoft.Office.Interop.Excel.Chart
Remarks
If Before and After are both omitted, the new chart is inserted before the active sheet.