Chart.ApplyCustomType Method

Artykuł
07/25/2011

Applies a standard or custom chart type to a Chart control.

Namespace: Microsoft.Office.Tools.Excel
Assembly: 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
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 creates a Chart and then uses the ApplyCustomType method to apply the 3-D pie chart type to the chart. The example does not specify a value for the optional TypeName parameter because a standard chart type is being used.

Private Sub Create3DPieChart()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.ApplyCustomType(Excel.XlChartType.xl3DPie)
End Sub

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

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.ApplyCustomType(Excel.XlChartType.xl3DPie, 
        missing);
}

.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.

Udostępnij za pośrednictwem