Month End Date Ticks
 

Hello,

In Excel 2003 I could use daily data starting on, say, 31 Dec 2005 and
ending some years later for a line chart. If in the x-axis settings I
selected both Major and Minor units to 3 Months with Base units as Days I
would get ticks at each calender quarter end. In this example; 31 Dec 2005,
31 Mar 2006, 30 Jun 2006, and so on. However, in Excel 2007 the axis
switches over to start of month ticks; 31 Dec 2005, 31 Mar 2006, 1 Jul 2006,
and so on.

Does anyone know what is going on with the date x-axis in Excel 2007? It
seems to be a bug as I have tried all manner of settings and am unable get
the x-axis to behave. It is a major issue here. Has Microsoft regonised
this as a bug? Are they doing anything to fix it? Has it already been fix
in a service pack or hot-fix? 2007 has been out for a while and I thought
by waiting a while before the upgrade that we would miss all the big bugs.
Apparently not. This is rather urget as it makes Excel useless for charting
here as we need month end ticks for 95% of charting.

Help. Please.

Ed

Month End Date Ticks
 

Hi,

Looks okay in xl2007 with SP2 applied.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ed" wrote in message
...
Hello,

In Excel 2003 I could use daily data starting on, say, 31 Dec 2005 and
ending some years later for a line chart. If in the x-axis settings I
selected both Major and Minor units to 3 Months with Base units as Days I
would get ticks at each calender quarter end. In this example; 31 Dec
2005, 31 Mar 2006, 30 Jun 2006, and so on. However, in Excel 2007 the
axis switches over to start of month ticks; 31 Dec 2005, 31 Mar 2006, 1
Jul 2006, and so on.

Does anyone know what is going on with the date x-axis in Excel 2007? It
seems to be a bug as I have tried all manner of settings and am unable get
the x-axis to behave. It is a major issue here. Has Microsoft regonised
this as a bug? Are they doing anything to fix it? Has it already been
fix in a service pack or hot-fix? 2007 has been out for a while and I
thought by waiting a while before the upgrade that we would miss all the
big bugs. Apparently not. This is rather urget as it makes Excel useless
for charting here as we need month end ticks for 95% of charting.

Help. Please.

Ed