Plot text with numbers

12 次查看（过去 30 天）
Ivan Mich
Ivan Mich 2020-9-8
评论： Star Strider 2020-9-10
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?

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2020-9-8
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.
.

更多回答（1 个）

KSSV
KSSV 2020-9-8
编辑：KSSV 2020-9-8
[num,txt,raw] = xlsread("test.xlsx") ; % can also use readtable
plot(num)
xticklabels(txt)
  4 个评论
显示 2更早的评论
KSSV
KSSV 2020-9-8
编辑：KSSV 2020-9-8
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
Ivan Mich 2020-9-8
KSSV I am sorry, but still not working

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Annotations 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by