Plot text with numbers

Hello,

I have a question about a code. I have one file in which:

The first column has cell (text) arrays

The second has numbers (double)

In my plot x axis has text and y axis has numbers

I would like to plot x axis with y axis.

I am uploading this file.

How could I make it?

Answer 1

[Star Strider]

Try this:

T1 = readtable('test.xlsx');
vars = T1.Properties.VariableNames;

figure
plot(T1{:,2})
Ax = gca;
Ax.XTick = 1:numel(T1{:,1});
Ax.XTickLabel = T1{:,1};
xlabel(vars{1})
ylabel(vars{2})

producing:

Note that table objects have specific indexing and variable reference requirements. The readtable function was introduced in R2013b.

.

[Ivan Mich]

Thank you very much !!!

[Star Strider]

As always, my pleasure!

Answer 2

[KSSV]

[num,txt,raw] = xlsread("test.xlsx") ;  % can also use readtable
plot(num)
xticklabels(txt)

[Ivan Mich]

KSSV I am sorry but your solution is not working

[Ivan Mich]

In x axis are showing numbers and NOT text

[KSSV]

See to it that ...the text should be all your text in cells....

T = readtable("test.xlsx") ; 
plot(T.2)
xticklabels(T.1)

[Ivan Mich]

KSSV I am sorry, but still not working