View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.