Setting X-Axis with Text Labels
显示 更早的评论
My question is related to the code pasted.
In line 4 of the code Variable "Tools" has the string of Text that is extracted from the excel file but to set it as x-lables i had to list them out again. Could someone suggest me solution where i can use the variable with strings in my code to be used as lables and not individually listing them out.
Thanks
Sai
[filename,pathname] = uigetfile("*.xlsx");
A = fullfile(pathname,filename);
num = importdata(A);
Tools = num.textdata(3:end,1);
Prices = num.data(1:6,1);
bar(Prices)
set(gca,'xticklabel',{'Table Saw','BandSaw','Jointer','Planer','Dust Collector','Calipers'});
1 个评论
Ameer Hamza
2020-5-20
Are these labels present in your xlsx file?
采纳的回答
Try this. If it doesn't work, please elaborate.
set(gca,'XTick',1:6,'XTickLabel',Tools)
I assume Tools is the cell array of 6 x-tick labels.
An improvement that doesn't rely on hard-coded indices,
set(gca,'XTick',1:numel(Prices),'XTickLabel',Tools)
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
