charts with Timestamps - only date part taken into account

[F Trouwaen]

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 ?

 

[Jon Peltier]

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/ChartsHowTo/CatVsValueAxis.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

- Jon