Share via


ChartSheet.GapDepth Property

Definition

Gets or sets the distance between the data series in a 3-D ChartSheet, as a percentage of the marker width.

public:
 property int GapDepth { int get(); void set(int value); };
public int GapDepth { get; set; }
member this.GapDepth : int with get, set
Public Property GapDepth As Integer

Property Value

The distance between the data series in a 3-D ChartSheet, 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.ChartSheet to 400 percent of the marker width.

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;
}
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

Applies to