Series overlap/gap width with VBA

  • Thread starter Thread starter K Dales
  • Start date Start date
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
 
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
 
Back
Top