Share via


ChartSheetBase.GapDepth Property

Gets or sets the distance between the data series in a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase, as a percentage of the marker width.

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 Property GapDepth As Integer
public int GapDepth { get; set; }

Property Value

Type: System.Int32
The distance between the data series in a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase, as a percentage of the marker width. The value of this property must be between 0 and 500.

Examples

The following code example uses the GapDepth property to set the distance between the data series in the current Microsoft.Office.Tools.Excel.ChartSheetBase to 400 percent of the marker width.

Private Sub AdjustGapDepth()
    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.GapDepth = 400
End Sub
private void AdjustGapDepth()
{
    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.GapDepth = 400;
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace