Chart shows all month-ends as 30th,some should be 31st

[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

 

[Glen Millar]

Hi Alan,

I'm just going through unanswered posts cleaning up. I wonder if your
Regional Settings such as time zone is correct? I tried it here and don't
have the same problem. Else, can you send me an example, please?

--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant

 

[Glen Millar]

Alan,

Another thought. How are your cells formatted? Particularly, are your cells
formatted to a "Date" format and does the dialogue box list a leading
asterisk? Like *3/30/06? These types of formats are dependant on time zone
and operating system.

--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant

 

[John Wilson]

Glen

I get this problem too

Im in the UK / 2003 on xp pro with all service packs

I only seem to get it if the start month is a 30 day month as in the example
above.

Strange or what!
--
-----------------------------------------
Did that help?
_____________________________
John Wilson
Microsoft Certified Office Specialist

 

[John Wilson]

Actually it goes wrong for me if you start with anything BUT a 31 day month.

Starting with 31/01/04 it even gets the leap year!!
--
-----------------------------------------
Did that help?
_____________________________
John Wilson
Microsoft Certified Office Specialist

 

[Glen Millar]

John,

it is usually the US that gets their dates mucked up! The Poms and aussies
have it sorted. Strange!

--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant

 

[Alan Z. Scharf]

Glen,


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