charts with Timestamps - only date part taken into account

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

F Trouwaen - 04 Sep 2006 09:06 GMT

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 ?

Reply to this Message

Jon Peltier - 05 Sep 2006 03:07 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> when plotting a chart with timestamps (9/28/05 3:05 AM) used on the
> X-axis,
[quoted text clipped - 4 lines]
> where
> date and time are taken into account on a chart ?

Reply to this Message