GapDepth Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns or sets a Long specifying the amount of spacing along the z-axis for adjacent data series in a three-dimensional chart. Valid values range from 0 to 500. Read/write.

expression.GapDepth

expression   Required. An expression that returns a ChChart object.

Remarks

Setting this property to a value of 100 results in the gaps that are the same thickness as the data series series.

Example

This example converts the first chart in Chartspace1 to a 3-D Column chart and then sets the gap depth of the chart.

  Sub SetGapDepth()

    Dim cht3DColumn As ChChart

    ' Set a variable to the first chart in Chartspace1.
    Set cht3DColumn = ChartSpace1.Charts(0)

    ' Change the chart to a 3-D Column chart.
    cht3DColumn.Type = chChartTypeColumn3D

    ' Set the gap depth.
    cht3DColumn.GapDepth = 75

End Sub