Chart.SurfaceGroup Property

Gets a ChartGroup object that represents the surface chart group of a 3-D chart.

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

Syntax

'Declaration
ReadOnly Property SurfaceGroup As ChartGroup
    Get

ChartGroup SurfaceGroup { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.ChartGroup
A ChartGroup object that represents the surface chart group of a 3-D chart.

Examples

The following code example creates a Chart and then uses the SurfaceGroup property to enable 3-D shading.

Private Sub UseSurfaceGroup()
    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.xlSurface

    Chart1.SurfaceGroup.Has3DShading = True
End Sub

private void UseSurfaceGroup()
{
    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.xlSurface;

    chart1.SurfaceGroup.Has3DShading = 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