ChartSheet.GapDepth Property (2007 System)
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
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Property GapDepth As Integer
'Usage
Dim instance As ChartSheet
Dim value As Integer
value = instance.GapDepth
instance.GapDepth = value
public int GapDepth { get; set; }
public:
property int GapDepth {
int get ();
void set (int value);
}
public function get GapDepth () : int
public function set GapDepth (value : int)
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
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.