stacked bar chart - problem adjusting bar width - Excel 2007

J

jglock

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
 

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

Stacked Bar Chart 1
Doughnut Chart linked with the slicer in the pivot table 0
Setting Bar Width in a Bar Chart 1
sideways stacked bar charts with line series on the same axis 0
How to create a bubble chart with more than 2 variables. 0
how to add error bars into bar chart 1
Excel Bar Charts Issue - How Dynamic can charts be? 0
VBA to set the font size for the axes of a bar chart 1

Top