ChartSheet.GapDepth Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

Int32

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