Charting Dated Data
 

I have a small file, using only 6 rows and 6 columns. A1 has the word Date
in it, A2 through A6 has the dates, 1/1/08, 1/8/08, 1/15/08, 1/22/08, and
1/29/08.
B2 through B6 has person's names and the cells from B2 through E6 contains
numerical data. I am attempting to create a column chart, with the weekly
dates on the X axis and the names in the legend, each column represents an
individual.
The problem is I am getting a lot of dates between the entered dates, every
other day is showing up on the X axis, cluttering up the axis and setting the
column widths very narrow. The gap width is around 10.
I need to supress those unwanted dates and widen the columns in the chart.
Any suggestions to explain this behaviour.
Thank you
Marsh

Charting Dated Data
 

Correction, that is B1 through E1 that contains the names. I was thinking
ahead

"Marsh" wrote:

I have a small file, using only 6 rows and 6 columns. A1 has the word Date
in it, A2 through A6 has the dates, 1/1/08, 1/8/08, 1/15/08, 1/22/08, and
1/29/08.
B2 through B6 has person's names and the cells from B2 through E6 contains
numerical data. I am attempting to create a column chart, with the weekly
dates on the X axis and the names in the legend, each column represents an
individual.
The problem is I am getting a lot of dates between the entered dates, every
other day is showing up on the X axis, cluttering up the axis and setting the
column widths very narrow. The gap width is around 10.
I need to supress those unwanted dates and widen the columns in the chart.
Any suggestions to explain this behaviour.
Thank you
Marsh