Changing the Width of Bars in a Horizontal bar Graph
 

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 :)

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

In article , Ott1
@discussions.microsoft.com says...
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 :)

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/ChartsH...thColumns.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=533

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


Tushar Mehta wrote:

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