ChartGroup.Overlap property (Excel)
Specifies how bars and columns are positioned. Can be a value between -100 and 100. Applies only to 2D bar and 2D column charts. Read/write Long.
Syntax
expression.Overlap
expression A variable that represents a ChartGroup object.
Remarks
If this property is set to -100, bars are positioned so that there's one bar width between them. If the overlap is 0 (zero), there's no space between bars (one bar starts immediately after the preceding bar). If the overlap is 100, bars are positioned on top of each other.
Example
This example sets the overlap for chart group one to -50. The example should be run on a 2D column chart that has two or more series.
Charts("Chart1").ChartGroups(1).Overlap = -50
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for