I needed little help on getting a chart which plots - time and date.
Time Date
---------------------
10:58:00 01/06/2013
11:14:00 02/06/2013
08:45:00 03/06/2013
11:32:00 04/06/2013
11:13:00 05/06/2013
I want x axis to show dates and y axis to show time. Dates on weekly interval and time on three hours interval. I got the time correct on Y axis. On X axis dates show up from 1/1/1900 to 18/3/1900. If I try it with small simple data I get it perfect marked line chart but here i have almost 100 rows.
Will you please help ? Could that be an issue with format type in date column ?
Bookmarks