Share via


ChartSheet.GapDepth Property

Gets or sets the distance between the data series in a 3-D Microsoft.Office.Tools.Excel.ChartSheet, as a percentage of the marker 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 GapDepth As Integer
int GapDepth { get; set; }

Property Value

Type: System.Int32
The distance between the data series in a 3-D Microsoft.Office.Tools.Excel.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 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

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace