ChartSheet.ApplyCustomType Method

Article
01/07/2014

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

Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

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

void ApplyCustomType(
    XlChartType ChartType,
    Object TypeName
)

Parameters

ChartType
Type: Microsoft.Office.Interop.Excel.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 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);
}

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Partager via