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.