plotting imported excel data containing date

1 visualizzazione (ultimi 30 giorni)
Suaad Zakwani
Suaad Zakwani il 12 Feb 2020
Commentato: Suaad Zakwani il 12 Feb 2020
Hello,
I am trying to plot a data imported excel data containing date column and a value
-------------------------------------
clear all
dataset = readtable('Manah.xlsx');
z = table2timetable(dataset);
x= dataset(:,1);
y= dataset(:,2);
plot (x,y)
---------------------------------------
and this erro shows up:
Error using tabular/plot
Too many input arguments.
  2 Commenti
BN
BN il 12 Feb 2020
Modificato: BN il 12 Feb 2020
Hello try this:
clear
dataset = readtable('Manah.xlsx');
%if column1 is your date column (insert variablename instead of column 1 and 2)
dateset.Column1 = datetime(dateset.Column1,'InputFormat','dd.MM.yyyy hh:mm:ss:SSS');
dataset.Column2 = str2double(dateset.Column2);
z = table2timetable(dataset);
plot(z.Column1,z.Column2)
Suaad Zakwani
Suaad Zakwani il 12 Feb 2020
Thanks alot,
I modified it a bit and it worked

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by