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

On Mon, 25 Aug 2008, in microsoft.public.excel.charting,
bronxbabe said:
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.

Temporarily remove the heading above the "weeks" column at the left
before running the wizard, then put it back again when you've created
your chart. The wizard looks for a block of blank cells at the top left
to decide what (and how many) rows and columns to use as its series
names and category axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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