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

Answer 1

[Cris LaPierre]

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.

You can use xtickformat function to modify the display format of the datetime values.

See more info here.

[Amir Hosein Shokouhy]

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]

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]

It's working now, thank you!