Excel date column export into Matlab and plot

Hi, Please I have excel file that conntains a date column and another column. I wish to plot the date on x axis and the second column on y axis. I have problem with date column in matlab. Please assist.

3/1/2014  7080.351
4/1/2014  6489.479
5/1/2014  5848.211
6/1/2014  5275.638
7/1/2014  4875.981
8/1/2014  4461.803
9/1/2014  4113.059
10/1/2014  3840.401
11/1/2014  3629.337
12/1/2014  3466.029
1/1/2015  3315.5
2/1/2015  3187.037

Please assist on how to plot this using Matlab. Thanks Isa

[Jan]

We now know, that you have problems. But we do neither see the code, not do we know which problems you have. So please take the chance to edit the original question and add any details.

[Isa Isa]

the problem is that I want to write matlab code to plot the data I sent earlier contained in excel file.

3/1/2014  7080.351
4/1/2014  6489.479
5/1/2014  5848.211
6/1/2014  5275.638
7/1/2014  4875.981
8/1/2014  4461.803
9/1/2014  4113.059
10/1/2014  3840.401
11/1/2014  3629.337
12/1/2014  3466.029
1/1/2015  3315.5
2/1/2015  3187.037

I hope it is clear now. Thanks

[Jan]

No, this does not help. Do you have a computer? Is an OS installed? Do you have Matlab and Excel installed? Which OS are you using? Are you able to use XLSREAD already? Did you implement it and how do the imported data look like? Is "2/1/2015" a string in the imported data or the display of a serial date number inside Excel? Did you manage the import successfully already and need the plot() command only? Or does the plotting work and you are looking for the datetick() function to show the date in a nicer format?

Please take into account, that the readers in the forum do not have the faintest idea about the current status of your program. So show us, what you have done so far and ask for one specific problem. The need to guess a detail reduces the chance to get a useful answer by 95% (the remaining 5% belong to Walter, who has a crystal ball like power to guess, what the people want).

Please avoid to post multiple questions about one problem. This wastes the time of the readers only. See http://www.mathworks.com/matlabcentral/answers/67342-excel-date-column-plot-in-matlab.

[Isa Isa]

Thanks Jan. This is my code. data=xlsread('DataTest','Sheet1'); q=data(:,2); time=data(:,1);

Error message

Attempted to access data(:,2); index out of bounds because size(data)=[193,1].

[Isa Isa]

Thanks Jan. This is my code. data=xlsread('DataTest','Sheet1'); q=data(:,2); time=data(:,1);

Error message

Attempted to access data(:,2); index out of bounds because size(data)=[193,1].

Matlab is not reading the first column of the excel file that contains the date so it takes the second column as the first column as a result it could not find second column. Please help

[Isa Isa]

Hi, I have this code wt=xlsread('DataTest','sheet1'); datecol = 1; wt(:,datecol) = wt(:,datecol) + datenum('30-Dec-1899'); x=wt(:,1); qo=wt(:,2); plot(x,qo);

How do I use datetick to get the x (date axis) in day-month-year ('dd-mmm-yyyy') format? Thanks Isa