I have lots of data based on weekly results, and would like to chart this
data by week. When I create bar charts from this data **without** the dates
on the x-axis, the charts are nicely spaced and look like a normal bar chart.
However, when I add the dates as the x-axis labels, Excel converts it to a
time series chart, and the scale changes. Instead of maybe 8-10 nicely sized
bars with reasonable gaps, I now have very narrow bars spread by large gaps.
I know I can change the options to increase the bar size and reduce the gap,
but at best it doesn't come close to the non-time series bar chart.

I'm sure there's some way to override this feature in Excel, but I haven't
been able to figure it out. The only option I've found is to convert the
dates to text, then use the text for the x-axis labels. Is there an option
I'm missing on this?

Thanks,
Todd