View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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 ?