Plot x axis in date format

5 次查看（过去 30 天）
Nora Rafael
Nora Rafael 2020-4-17
评论： Peter Perkins 2020-4-27
I want to load and plot a dataset, with the x-axis in date format:
When I make my plot using the below code:
data=xlsread('XXX.xlsx');
Date=data(:,1); %week start date
Y=data(:,4);
plot(Date,Y,'ob');
But I get a strange x-axis
How can I change the x-axis to the date format in the excel? and then to a number in months?
  3 个评论
显示 1更早的评论
Nora Rafael
Nora Rafael 2020-4-17
Unfortunately I can't attach it :(
Could you give an example of how it can be implemented?
Peter Perkins
Peter Perkins 2020-4-27
Based on your (I guess) screenshot of an excel spreadsheet, you have a mix of text and dates in that column of the spreadsheet. That's bad news. Strongly recommend that you clean that up before doing anything. Maybe you can clean it up in MATLAB, but better to deal with the source. I have no idea what you'd even get back in the numeric output from your call to xlsread.
Once you clean that up, stay away from xlsread, and use readtable. Depending on what version of MATLAB you are using, you may get datetimes automatically, or you may get text and have to convert. If you get a cell array that is a mix of text and numbers, you haven't cleaned up the file. In very recent versions of MATLAB, use readtimetable. At that point, you can just plot vs. the datetime. Muhammad shows that, although I think the file he's using is very different than what you have.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Mehmed Saad
Mehmed Saad 2020-4-17
Take this as an example
T = readtable('Test.csv');
t= datetime(strrep(strrep(T.time,'T',' '),'Z',''));
figure,plot(t,T.long_E,'.')
In this example i converted the data i ve into time series so the plot is
  1 个评论
Mehmed Saad
Mehmed Saad 2020-4-17
You can convert your excel datetime usinng the following format
datetime(Date,'Format','MM/dd/yyyy')
where Date must be in the form of string

请先登录，再进行评论。

Ameer Hamza
Ameer Hamza 2020-4-17

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by