Changing the Width of Bars in a Horizontal bar Graph

[Ott1]

Hi, I cannot seem to figure out who to change the width of each bar in a
horizontal bar graph.

Can someone please advise me as to how I could do this.

Thanks in advance

 

[Tushar Mehta]

Double click the plotted series and in the resulting dialog box select
the Options tab. In there adjust the 'Gap Width' value.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

BTW, this changes all bars, since they cannot be changed individually.

Not without tricks, anyway. These are tricks for making variable-width
column charts, and the tricks mostly work for bar charts as well:

http://peltiertech.com/Excel/Charts/VarWidthColumn.html
http://peltiertech.com/Excel/ChartsHowTo/VariableWidthColumns.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=533

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______