Chart shows all month-ends as 30th
 

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

Chart shows all month-ends as 30th
 

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

Chart shows all month-ends as 30th
 

Alan:
I assume neither of the datum formats give you what you want, so I didnt
bother testing them all. I tried a work around as follows:
Assuming yr datums are in A1 downwards, add three columns behind your data.
(B,C,D) In B1 type the formula =Text(A1,"mm") [This returns a two number
digit for the "month" specified in A1]. In C1 =Text(A1,"dd"). [This returns
a two number digit for the "day" specified in A1]. In D1
=concatenate(B1,"-",C1). [This returns the format "mm-dd".
Now go to yr chart, right click and select Source Data... Under the series
tab define the range in D1 downwards as category X axis. It should show
09-30, 10-31, etc in your chart now (you can change the "-" of course by any
separator you want, or add the year if needed in a similar way as described).
In my Excel 2003 it returns the format you seek, so I hope it works for you.
GL,
Henk


"Alan Z. Scharf" wrote:

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

Chart shows all month-ends as 30th
 

Bernard & HEK,

The answer is to go to Chart Options on the menu, check Primary Axis (X),
radio button Category, uncheck Secondary Axis(Y).

Thanks for your replies.

Alan

"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