How about changing the Base Unit to months on the Scale tab of Format Axis
Then you get the first of each month.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alan Z. Scharf" wrote in message
...
Hi,

1. I have an area chart covering six months of data

09/30/05
10/31/05
11/30/05
12/31/05
01/31/06
02/28/06
03/31/06

2. However, the X-axis shows 9/30/05 10/30/05 11/30/05 12/30/05
1/31/05 2/28/06 3/30/06.

The only month endit gets right is 2/28.

3. Can anyone help with settings that would get 31st in relevant months?


4. Current X-Axis scale settings are below, all non-auto:

Min 9/30/2005
Max 3/31/2006
Base Unit Days
Major Unit 1 Month
Minor Unit 1 Month
Y Crosses 9/30/2005


Thanks.

Alan