Is the category axis showing dates? And is the data weekly, not daily? This
means you have six blanks dates for each date with a value, and therefore
the gaps are very wide. Change to a category scale axis. Excel 2003: Chart
menu Chart Options Axes tab, choose Category option for the Category
axis. Excel 2007: Format Axis, about midway down the first tab, choose Date
Axis.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"Shelly" wrote in message
...
I have a column chart created and the columns are like pin stripes - I have
tried reducing the gap and so forth but can't find a way to make the
columns
wide enough to be useful.