Share via

ChartSheetBase.GapDepth Property

  • Reference

Definition

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

Gets or sets the distance between the data series in a 3-D ChartSheetBase, 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

Int32

The distance between the data series in a 3-D 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 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