too many input argument while plotting date and time

Question

chanz agrawa 2019-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457492-too-many-input-argument-while-plotting-date-and-time

回答： Cris LaPierre 2019-4-20

SolarG55.xlsx

在 MATLAB Online 中打开

i want to plot this on matlab. the code i am trying is

[~,~,v]=xlsread('solarg55.xlsx')
v=v(2:end,:);
x=datenum(v(:,1),'dd/mm/yyyy HH:MM:SS')
y=cell2mat(v(:,2))
[idx,idx]=sortrows([x,y])
plot(x(idx),y(idx))
xticks=get(gca,'Xtick')
set(gca,'xticklabel',datestr(xticks,'dd/mm/yyyy HH:MM:SS'))

but it gives me this error

Error using date
Too many input arguments.

2 个评论
显示无隐藏无

KALYAN ACHARJYA 2019-4-20

编辑：KALYAN ACHARJYA 2019-4-20

Pls Attach solarg55.xlsx

chanz agrawa 2019-4-20

edited

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2019-4-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457492-too-many-input-argument-while-plotting-date-and-time#answer_371471

在 MATLAB Online 中打开

Not sure exactly what your desired outcome is. However, why not use readtable, which loads your data into a table? It can handle your dates automatically as datetimes. When you plot with a datetime, the axis labels are dates. No need to set the label manually. You can also sort a table.

Try this code:

opts = detectImportOptions('solarg55.xlsx');
data = readtable('solarg55.xlsx',opts);
data.Properties.VariableNames = {'X','Y'};
data = sortrows(data,{'X','Y'});
plot(data.X,data.Y)