How can I plot a bar char from an excel file?

11 次查看（过去 30 天）
Behrad Ze
Behrad Ze 2023-1-28
回答： Simon Chan 2023-1-28
I wan to plot a bar chart like the attached picture from the attached excel file sample. The problem is that I can not use the first column as ticks. It is shown by numbers.I tried some other techniques but it did not work since all the letter were not shown on the plot. I would be thankful if someone could help me. Thanks!
csvfiles = dir('*.csv');
for file = csvfiles'
T = readtable(file.name) ;
A = table2array(T(2:end,2:end)) ;
l = T.(1) ;
bar(A)
end

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

采纳的回答

Simon Chan
Simon Chan 2023-1-28
Ran in:
Try the following:
T = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1276650/Sample.csv');
X = categorical(T.Var1); % Convert to categorical
Y = table2array(T(:,2:3));
bar(X,Y)

更多回答（0 个）

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by