MATLAB Answers

0

Contour Plot Date/Depth/Temperature

Asked by Dennis Mayk on 18 May 2018 at 11:49
Latest activity Edited by Dennis Mayk on 19 May 2018 at 10:27

I am trying to create a Contour Plot containing the values: Date/Waterdepth/Temperature. The table looks like that in Excel, were blue=depth, orange=dates and green=temperature:

Here is my code and the error I receive:

data = readtable('temperatur.xls','Range','A1:H21');
x = data(2:end,1);
y = data(1,2:end);
z = data(2:end,2:end);
contourf(x, y, z);

It appears to me that Matlab has an issue with the date-time format. I have tried to use numerous different date formats but could not get it to work. The XLS file is attached to this question. Any help is very much appreciated!

  1 Comment

Okay, so I figured out how to solve this and just want to share it here if somebody else faces the same problem. The the problem seemed to be the formatting of my excel dates: DD.MM.YYYY when I changed these to the format MM.DD.YYYY I could use the datenum(t) function to transfer the dates to matlab dates and contourf worked like a charm.

Sign in to comment.

0 Answers

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today