Thread
:
charts with Timestamps - only date part taken into account
View Single Post
#
2
Posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
Posts: 6,582
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 ?
Reply With Quote
Jon Peltier
View Public Profile
Find all posts by Jon Peltier