stacked bar chart - problem adjusting bar width - Excel 2007
 

I need some help with adjusting the width of the bars on a stacked bar
chart. If I create a chart with less than a dozen observations, I can
expand the width by "Format Data Series Series Options and setting
the "gap width" to 0% or "no gap". Bars widen to fill the space as
advertised.

However when I try to apply the same method to a chart with 50
observations, A significant gap contiinues to exist. Gap is about
about 7 to 10 times wider than the bar. Does anyone have suggestions?

I have some VBA experience, so if a solution exists with manipulating
excel objects, I'm willing to try that.

Thanks to all