Plot data with date and time as the x axis
显示 更早的评论
Hello,
Can anyone help me plot this table data? I want to have the date and time as x - axis and the other variables as 6 differnent plots all in the same
figure.
Thanks,
Amir
采纳的回答
Cris LaPierre
2022-3-4
0 个投票
Read the table in as a table using readtable. You will want to make sure column 1 is read in as a datetime. This 'should' happen automatically, but may depend on your version of MATLAB. Once in MATLAB, you can just plot using the datetime variable as your x input. As a datetime, it will automatically show date and time.
3 个评论
Amir Hosein Shokouhy
2022-3-7
This is the code that I am using:
xlsx_name = 'C:\\Air Temperature\MQLoad (1).xlsx'
tab = readtable(xlsx_name);
figure
stackedplot(tab)
This is what I get:
When I change the code to:
stackedplot(tab(:,1),tab(:,2))
I get this error:
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original
column headers are saved in the VariableDescriptions property.
Set 'PreserveVariableNames' to true to use the original column headers as table variable names.
Error using stackedplot (line 71)
Variables to plot must be a valid data type.
Error in Preliminary_Time (line 85)
stackedplot(tab(:,1),tab(:,2))
Cris LaPierre
2022-3-7
编辑：Cris LaPierre
2022-3-7
Try this syntax: stackedplot(___,'XVariable',xvar)
xlsx_name = 'C:\\Air Temperature\MQLoad (1).xlsx'
tab = readtable(xlsx_name);
stackedplot(tab,'XVariable','Var1')
If that doesn't work, please share your spreadsheet. You can attach it to your post using the paperclip icon.
Amir Hosein Shokouhy
2022-3-7
更多回答（0 个）
类别
在 帮助中心 和 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 
