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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing gap width between specific columns 7
Setting column width in a table with a macro is not working 0
stacked bar chart - problem adjusting bar width - Excel 2007 0
Bar Chart (2D) won't let me 'gap' one bar behind the other? 0
Different width of columns (series) in clustered charts 2
Moving data series horizontally (offset) to prevent overlapping 2
Problem with SET & REF function 0
Excel 2007 chart line width + axis labelling with VBA 6

Top