How can I create a plot like this?

I have a timetable called "Tc1"(attached file) in which, the Column1streamId column contains certain information. I want to create a plot in which in the x axis I put the information of the Column1streamId, in the y axis I put the time (from 12:00 AM to 12:00 AM of the next day). How can I do it?

Answer 1

[jonas]

Kind of looks like a scatter plot. You can try this:

%%Load data
data = load('Tc1.mat');
Tc1=data.Tc1;
t=Tc1.t

%%time of day (y)
y=duration([hour(t) minute(t) second(t)])

%%date (x)
x=datetime(year(t),month(t),day(t))

%%color (z)
[z,groups]=findgroups(Tc1.Column1streamId);

scatter3(x,y,z,[],z)
xtickformat('MMM-dd')
view([0 90])
set(gca,'xtick',unique(x))

Obviously it will look more similar when you have more days.

[Erica Corradi]

I tried your code, but I have this error:

Error using scatter3 (line 123) Data inputs must match the axis configuration. A numeric axis must have numeric data inputs or data inputs which can be converted to double.

Error in AAL (line 323) scatter3(x,y,z,[],z)

ps: thanks jonas for your help!

[jonas]

Did you copy paste my code exactly, without adding more data?

What is the class of x, y, z in your workspace?

[Erica Corradi]

I copied your code exactly. X is datetime; y is duration and z... I don’t remember because now I haven’t the computer with MatLab.

[jonas]

Same here, im on mobile but will check potential errors tonight

Btw did you test the code in a clean script? Your error message suggests you have implemented it as part of a larger script.

[Erica Corradi]

Ok thanks a lots jonas!!!

[Erica Corradi]

I tried both situations: in a clear script and in my large script. And both don’t work.

[jonas]

Just to be sure, run this script as is. It should output the figure below. Apparently the error message displays if the x-axis is set to double, which it is if you have already plotted some double on it. Possibly, this could happen if you are trying to plot the scatter3 on an already existing figure. Does an axis appear before the script stops?

What release are you running?

[Erica Corradi]

Ok, as soon as I can, I try it. I have the last version of MatLab.

[jonas]

Okidoki. We have the same script, the same data and the same release. I don't see how it can not work. Let me know how it goes!

[Erica Corradi]

Thanks jonas, it works! Now I'm trying to make it work in my large script, using the Tc table created with the first chart (always made by you).

[jonas]

Awesome! Let me know if you run into trouble