x Axis inserts extra dates

J

Jerry

Hello,
I am charting values in two date columns, one date is 8/16/05 and the other
one is 9/1/05. The columns are side by side.

This use to be a piece of cake for me until I started using Excel 2003.
Now, instead of showing two dates on the X axis, it shows values for every
two days between 8/16/05 and 9/1/05. I found out that the X Axis scale was
showing a 2 day interval, however I was not able to make any changes in the
scale area to show only the two dates I wanted.

Any help would be appreciated.

thx/Jerry
 
E

Earl Kiosterud

Jerry,

If you have only two dates, then there's no reason to have a time-scale
axis, which attempts to space dates as a function of the dates and the
intervals between them. It does this by creating a category on the x axis
for every day, placing your items on that scale. Select the chart,
right-click it, Chart options - Axes. Set the x axis to Category.
Automatic will likely choose Time-scale, which you don't want.
 
Top