Plot time series

<< Click to Display Table of Contents >>

Navigation:  How do I? >

Plot time series

Advanced Edition only

If you have a column of date values, then you can use this as the X axis for Scatter, Line, Smooth Line or Area charts.

 

Tiem series chart with date as X axis

 

If you have a column of date/time values that increases by a fixed interval for each row, then you can treat this column as text for the X axis:

 

Charting a time-series that increases by a fixed interval.

 

If you have a column of date/time values that do not increase by a fixed interval for each row, then you can convert this date/time column to numeric values using the Calculate transform with the DateToJulianDay or DateTimeToMSecs options:

 

Charting a time-series that doesn't increase by a fixed interval.