charts with Timestamps - only date part taken into account
 

when plotting a chart with timestamps (9/28/05 3:05 AM) used on the X-axis,
only the 'Date' part is taken into account. The 'time' part is dropped.
When converting all timestamp to numbers (e.g. 38623,.12876) then of course
the chart is plotted correctly. How can I have a continuous timeline where
date and time are taken into account on a chart ?

charts with Timestamps - only date part taken into account
 

A time scale axis of a line chart only considers whole numbers (i.e., days,
not times). You need to make an XY chart, not a line chart. Note that the
terminology is misleading: either type chart can have any combination of
lines and markers. The difference is in the treatment of the X axis:

http://peltiertech.com/Excel/ChartsH...ValueAxis.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=190

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"F Trouwaen" <F wrote in message
...
when plotting a chart with timestamps (9/28/05 3:05 AM) used on the
X-axis,
only the 'Date' part is taken into account. The 'time' part is dropped.
When converting all timestamp to numbers (e.g. 38623,.12876) then of
course
the chart is plotted correctly. How can I have a continuous timeline
where
date and time are taken into account on a chart ?