Creating Bar Chart

[bronxbabe]

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

 

[Del Cotter]

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.

 

[Jon Peltier]

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