Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time axis format problems
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
Excel 2003- Charts- date and time format on x-axis of XY chart | Charts and Charting in Excel | |||
Time format - problems with calculation | Excel Discussion (Misc queries) | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Problems with time format in excel | Excel Worksheet Functions |