ChartSheet.DepthPercent Property

Gets or sets the depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width.

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
Property DepthPercent As Integer

int DepthPercent { get; set; }

Property Value

Type: System.Int32
The depth of a 3-D chart as a percentage of the Microsoft.Office.Tools.Excel.ChartSheet width (between 20 and 2000 percent)

Examples

The following code example uses the DepthPercent property to set the depth of the 3-D portion of the current Microsoft.Office.Tools.Excel.ChartSheet to 75 percent of the width of the Microsoft.Office.Tools.Excel.ChartSheet.

Private Sub AdjustDepth()
    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.xl3DBarClustered
    Me.DepthPercent = 75
End Sub

private void AdjustDepth()
{
    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.xl3DBarClustered;
    this.DepthPercent = 75;
}

.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

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace