Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Match Month in Date With Month in Header | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions |