How to plot data with corresponding dates

1 view (last 30 days)
I have a vector with data (1x9324 double) and another vector (1x9324 cell) with the corresponding dates. Both vectors are from an Excel sheet using 'xlsread'. The dates are in string format and not equidistant. e.g.
'02.01.2007 08:45:00'
to
'31.12.2008 12:27:00'
'31.12.2008 15:31:00'
'31.12.2008 16:35:00'
'31.12.2008 16:35:00'
'31.12.2008 16:35:00'
There are also dates wich are exactly the same. But I do not want to interpolate or take averages. I want to plot the data on the Y axis and the dates on the X axis, just month and year are enough. I tryed
startDate = datenum('02.01.2007');
endDate = datenum('31.12.2008');
xData = linspace(startDate,endDate,9324);
plot(xData,data_vector);
datetick('x','mmm,yy','keepticks');
But I'm afreid that the dates are now equidistant. Then I tryed
ts = timeseries (data_vector, datenum(date_vector));
plot(ts);
But both vectors changed in length and values. Maybe because the timeseries tool is taking averages of the data where the dates are the same.
System:
MATLAB 7.10.0 (R2010a)
Microsoft Excel 97-2003 Worksheet (.xls)
Windows 8.1 64Bit
Thanks in advance!

Accepted Answer

David Young
David Young on 16 Sep 2014
Edited: David Young on 18 Sep 2014
The problem is that you are using linspace to produce equally separated dates rather than converting each of the actual dates. Try
plot(datenum(dates, 'dd.mm.yyyy HH:MM:SS'), data_vector);
where dates is the cell array of strings containing your dates.
[Answer edited to include format string for datenum]
  3 Comments
David Young
David Young on 17 Sep 2014
Yes, you're right - the date string isn't in the standard format, so isn't being converted correctly. This should work though:
datenum(dates, 'dd.mm.yyyy HH:MM:SS')
David Young
David Young on 18 Sep 2014
Note: answer edited to reflect this.

Sign in to comment.

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!