Edit

Share via

Chart.GapDepth property (Project)

  • Article

Gets or sets the distance between the data series in a 3D chart, as a percentage of the marker width. Read/write Long.

Syntax

expression.GapDepth

expression A variable that represents a Chart object.

Remarks

The value of the GapDepth property must be between 0 and 500. The GapDepth property fails on 2D charts.

Example

The following example sets the distance between the data series in the chart to 200 percent of the marker width. The example should be run on a 3D chart.

Sub SetGapDepth()
    Dim chartShape As Shape
    Dim reportName As String
    
    reportName = "Simple 3D chart"
    Set chartShape = ActiveProject.Reports(reportName).Shapes(1)
    
    chartShape.Chart.GapDepth = 200
End Sub

Property value

INT

See also

Chart Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.