Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and Date Functions | Excel Worksheet Functions | |||
Matching month part of date only | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |