Thread: 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

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" <ascharf@grapevines.com> wrote in message
news:uS1u9qFdGHA.1792@TK2MSFTNGP03.phx.gbl...
> 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
>
>
>

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
>
>
>
>

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" <ascharf@grapevines.com> wrote in message
news:uS1u9qFdGHA.1792@TK2MSFTNGP03.phx.gbl...
> 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
>
>
>