Excel.Chart.GapDepth.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Chart.GapDepth property (Excel)	vbaxl10.chm149110	vbaxl10.chm149110	Excel.Chart.GapDepth	6020490a-1343-5b79-ff7d-197f78061420	04/16/2019	medium

Chart.GapDepth property (Excel)

Returns or sets the distance between the data series in a 3D 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 on Chart1 to 200 percent of the marker width. The example should be run on a 3D chart (the GapDepth property fails on 2D charts).

Charts("Chart1").GapDepth = 200

[!includeSupport and feedback]