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