How can I plot a bar char from an excel file?
20 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Behrad Ze
le 28 Jan 2023
Réponse apportée : Simon Chan
le 28 Jan 2023
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
0 commentaires
Réponse acceptée
Simon Chan
le 28 Jan 2023
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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Line Plots dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!