Chart.GapDepth Property

Excel Developer Reference

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500. Read/write Long.

Syntax

expression.GapDepth

expression   A variable that represents a Chart object.

Example

This example sets the distance between the data series in Chart1 to 200 percent of the marker width. The example should be run on a 3-D chart (the GapDepth property fails on 2-D charts).

Visual Basic for Applications
  Charts("Chart1").GapDepth = 200

See Also