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
|