The time scale axis has no Weeks setting. If Excel recognizes your dates as
dates, it will use Days instead, so for each weekly data point you will have
one column and six spaces, hence your thin columns. Change the time scale
axis to a regular category axis by going to Chart menu Chart Options
Axes, and selecting Category under Category (X) Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Hoosierquilt" wrote in message
...
Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is supposed
to
be in weekly intervals. If I do not include the cells with the weeks
listed
in my x axis labels field in the "Source Data", my columns look great -
nice
and wide, easy to see. Once I select my cells with my dates in them, the
columns get very skinny. I tried changing the gap and the overlap, with
no
success. Help! How can I get my columns to look nice and wide, and still
have my weeks listed in my x axis??