View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Alan Z. Scharf
 
Posts: n/a
Default 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