View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Time axis format problems

Hi,

I think you're going to have to resort to a custom axis.

Jon Peltier has a step by step for this type of problem at:

http://peltiertech.com/Excel/Charts/

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Fabian" wrote:

Hi

I would like to use a time axis to start at 1st January 1999, end at 20th
August 2008 and mark every 1st of the interim years with the number of the
year (i.e. 2000). But somehow, when I try to modify the time axis I am asked
to give a number around 36000 for the staring and ending time and I can only
set day differences for main lines. How can I handle the leap year
problematic.

Greets, Fabian