0 个投票

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

0 个投票

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.
.

2 个评论
显示 无 隐藏 无

Ivan Mich
Ivan Mich 2020-9-10
Thank you very much !!!
Star Strider
Star Strider 2020-9-10
As always, my pleasure!

请先登录，再进行评论。

更多回答（1 个）

KSSV
KSSV 2020-9-8
编辑：KSSV 2020-9-8

0 个投票

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

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Ivan Mich
Ivan Mich 2020-9-8
KSSV I am sorry but your solution is not working
Ivan Mich
Ivan Mich 2020-9-8
In x axis are showing numbers and NOT text
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

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Graphics Object Properties 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by