ChartSheet.ApplyCustomType Method (2007 System)

  • Article

Applies a standard or custom chart type to a Microsoft.Office.Tools.Excel.ChartSheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Sub ApplyCustomType ( _
    ChartType As XlChartType, _
    TypeName As Object _
)

'Usage
Dim instance As ChartSheet 
Dim ChartType As XlChartType 
Dim TypeName As Object

instance.ApplyCustomType(ChartType, TypeName)

public void ApplyCustomType(
    XlChartType ChartType,
    Object TypeName
)

public:
void ApplyCustomType(
    XlChartType ChartType, 
    Object^ TypeName
)

public function ApplyCustomType(
    ChartType : XlChartType, 
    TypeName : Object
)

Parameters

  • ChartType
    Type: XlChartType

    A standard chart type.

  • TypeName
    Type: System.Object

    The name of the custom chart type if ChartType specifies a custom chart gallery.

Remarks

Optional Parameters

For information on optional parameters, see The Variable missing and Optional Parameters in Office Solutions.

Examples

The following code example uses the ApplyCustomType method to set the current Microsoft.Office.Tools.Excel.ChartSheet to a standard chart type that uses clustered bars to display data.

Private Sub SetChartSheetType()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ApplyCustomType(Excel.XlChartType.xlBarClustered)
End Sub

private void SetChartSheetType()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ApplyCustomType(Excel.XlChartType.xlBarClustered, 
        missing);
}

.NET Framework Security

See Also

Reference

ChartSheet Class

ChartSheet Members

Microsoft.Office.Tools.Excel Namespace