Chart shows all month-ends as 30th

[Alan Z. Scharf]

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

 

[Bernard Liengme]

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

 

[HEK]

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]

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