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 An expression that returns a Chart object.

Return Value
Long

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: