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 <E50AE3D4-394B-4561-8C72-023334E656AC@microsoft.com>, 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.
>