plotting imported excel data containing date

1 view (last 30 days)
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 Comments
BN
BN on 12 Feb 2020
Edited: BN on 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 on 12 Feb 2020
Thanks alot,
I modified it a bit and it worked

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!