Is the X axis a date scale, but you only have one data point per week? Your
gap is comprised of six empty days' of data, plus seven times the nominal
gap. Change to a category axis type (Chart menu Chart Options Axes tab).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"PA" wrote in message
...
Thanks, that works, on most of our files that I experimented with.
However,
the file needing to have the columns widened because they are far to
narrow,
has a gap width of 10, and I do not know why.
"Jon Peltier" wrote:
Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"PA" wrote in message
...
One simple question, How do I make the columns in a column chart wider
that
they are created by Excel 2003?
Thanks for help.