Skip to content

Files

Latest commit

 

History

History
42 lines (24 loc) · 1.11 KB

Excel.ChartGroup.Overlap.md

File metadata and controls

42 lines (24 loc) · 1.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ChartGroup.Overlap property (Excel)
vbaxl10.chm568086
vbaxl10.chm568086
Excel.ChartGroup.Overlap
6ea1de1a-ecb4-d920-fc34-ed3bf3a767b4
04/20/2019
medium

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

[!includeSupport and feedback]