Plot Excel data for dates and time
12 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I am trying to plot a trend/ line graph for the data I attached. If possible, I would like to have graphs for each date.
2 comentarios
Star Strider
el 25 de Nov. de 2019
There are no data in the file you posted, only a list of dates.
Using:
T = readtable('hekp.xlsx','ReadVariableNames',0);
the first five rows are only:
Var1 Var2 Var3
__________________ _________ _______
11/8/2019 08:54:00 11/8/2019 0.37083
11/8/2019 08:58:00 11/8/2019 0.37361
11/8/2019 09:02:00 11/8/2019 0.37639
11/8/2019 09:25:00 11/8/2019 0.39236
11/8/2019 09:25:00 11/8/2019 0.39236
Note that ‘Var3’ are fractional days corresponding to the times in ‘Var1’.
Respuestas (1)
Pratheek Punchathody
el 19 de Nov. de 2020
You could import the excel file into the MATLAB workspace and use “readtable()” function to read the imported data. Line graphs can be created using the “plot()” function.
T = readtable('hekp.xlsx'); %Read imported table from the workspace
plot(T.Var1, T.Var3); %ploot Var1 with respect to x-axis and Var3 with respect to y-axis
Refer to the documentation of Read Spreadsheet Data into Table for further reference and parse the data from the table as required.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!