ChartSheetBase.SurfaceGroup Property

Gets a ChartGroup object that represents the surface chart group of a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.

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

Syntax

'Declaration
Public ReadOnly Property SurfaceGroup As ChartGroup

public ChartGroup SurfaceGroup { get; }

Property Value

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

Examples

The following code example uses the SurfaceGroup property to enable 3-D shading in the current Microsoft.Office.Tools.Excel.ChartSheetBase.

Private Sub UseSurfaceGroup()
    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.ChartType = Excel.XlChartType.xlSurface
    Me.SurfaceGroup.Has3DShading = True 
End Sub

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

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

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace