Series overlap/gap width with VBA

K

K Dales

Does anyone know how to set the series overlap and gap
width using VBA? Have looked through all the regular
reference material (including KB search) and can't find
any way to refer to these properties programatically.

Thanks!
K Dales
 
A

Andy Pope

Hi K,

The macro recorder is a good way to discover these properties.

It produced this code for me.

With ActiveChart.ChartGroups(1)
.Overlap = 20
.GapWidth = 50
End With

Cheers
Andy
 
Top