Plot text with numbers
35 views (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
Star Strider
on 8 Sep 2020
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 Comments
More Answers (1)
KSSV
on 8 Sep 2020
Edited: KSSV
on 8 Sep 2020
[num,txt,raw] = xlsread("test.xlsx") ; % can also use readtable
plot(num)
xticklabels(txt)
See Also
Categories
Find more on Axis Labels in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!