Chart.Parent Property

Gets the parent object for the Chart control.

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

Syntax

'Declaration
ReadOnly Property Parent As Object
    Get

Object Parent { get; }

Property Value

Type: System.Object
A ChartObject that represents the parent object for the Chart control.

Examples

The following code example creates a Chart and then uses the Parent property to select the parent.

Private Sub SelectParentObject()
    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

    ' Get and select the ChartObject parent.
    Dim parentObject As Excel.ChartObject = _
        CType(Chart1.Parent, Excel.ChartObject)
    parentObject.Select(True)
End Sub

private void SelectParentObject()
{
    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;

    // Get and select the ChartObject parent.
    Excel.ChartObject parentObject = 
        (Excel.ChartObject)chart1.Parent;
    parentObject.Select(true);
}

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

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace