How to plot Date on x axis and string on Y axis. Text annonation on Data points

Attacched excel sheet has the Date and string. I want to plot Time on x axis and string message on the y axis.

I want Text Annotations plots.

Thanks

[Walter Roberson]

In order to use strings on y axis they must be convertable tonnumeric or encodeable as orderable numeric. You have multiple distinct columns, a different quantity per row, and the strings have no obvious numeric representation. How does

{'Chip

sort relative to

message qpkin

?

[Walter Roberson]

text(datenumber, ycoordinate, 'text to show')

[Walter Roberson]

datacursormode with a custom update function.

[Walter Roberson]

Inside the callback, get axes CurrentPoint. Extract the x from that and find the closest x in the data. Use that to pull out the strings from the table. Return a cell array of character vectors; each entry will become a separate line in the datatip shown.

I am not going to do an implementation for you, as the result is going to look pretty poor. With that data, I believe that the kind of graph that is being proposed is nearly meaningless.

[Walter Roberson]

It is disappointing that the user chose to remove their discussion, making the topic hard to follow.

Answer 1

[KSSV]

Load data from excel to matlab using xlsread.

Use this to use labels along the axes:

https://in.mathworks.com/help/matlab/creating_plots/change-tick-marks-and-tick-labels-of-graph-1.html

Use this for dates

https://in.mathworks.com/help/matlab/ref/datetick.html

[KSSV]

MATLAB is rich in documentation......you should read from there with lot of exaples.