Bar width

[Tammy]

How do I change the gap width in my chart, without changing the bar width. As soon as a change the gap width do my bars are closer, my bars get very large. I would like to lessen the gap while keeping the bar width the same.

Thanks!

 

[Tushar Mehta]

You would have to shrink the size of the chart (or at least the plot
area).

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office

 

[Jon Peltier]

Tammy -

The bars and the gaps all add up to the total width. If you change gap,
the bar width will change, unless you also change the total width of the
chart.

- Jon