MSGraph Showing All Month-Ends as 30th.

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart shows all month-ends as 30th 3
Linking Child Timelines to Multiple Parents 0
MS Graph shows all month-ends as 30th 0
Chart shows all month-ends as 30th,some should be 31st 6
Chart Shows All Month-Ends as 30th 1
Time-value axis labels 5
Combine 2 Charts 2007 Excel 1
How to build subquery on aggregate query 0

Top