Q1311268. How to Eliminate Gaps Between Bars on a Chart
This article will explain how to remove space between the series of a bar chart.
The reason there are spaces between the bars on the chart is because some space is left for a border for each bar. To achieve the visual affect of having no break you can set the border to the same color as the bar. You should also set the Volume property to 100 ( so that the series will take up 100% of the chart area).
With Chart
.Volume=100
.Border=True
.BorderColor=Chart.Color(0)
End With