Does your data look like "1/2-1/8", "1/9-1/15", etc.? Excel doesn't know
these are date ranges, it thinks they are category text labels, and assigns
them values of 1 to N. You could use just the last date in each grouping,
and Excel will accept the dates as dates. Note that the bar chart will not
look very good, because for each weekly data point (bar), there will be six
days without data, and thus the gaps between bars will be wide. But this
kind of data is best in a line chart anyway.

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


"bronxbabe" wrote in message
...
I'm trying to create a bar chart with data from companies that spanning an
entire year, but displaying sales for each week. The sales data shows
data
for 1/1, then 1/2-1/8, 1/9-1/15, 1/16-1/22, etc... I created the chart
using
the wizard, used data from a sheet and all bars are created, but
displaying
each bar as 1-53 (meaning wk 1-53) because I left the default primary
axis,
category (x) axis at auto. My problem begins when i change that option
from
automatic to time-scale. The chart at that point still looks the same,
but
when I try to edit the Category Axis, the default scale is
1/1/1900-2/22/1900; major 1 day; minor 1 day. When i change the maximum
to
12/31 and change major unit at 7 days, it won't take it. it defaults back
to
2/22/1900. is there a limit here?

thanks in advance