Filter löschen
Filter löschen

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

20 Ansichten (letzte 30 Tage)
Behrad Ze
Behrad Ze am 28 Jan. 2023
Beantwortet: Simon Chan am 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

Akzeptierte Antwort

Simon Chan
Simon Chan am 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)

Weitere Antworten (0)

Kategorien

Mehr zu Line Plots finden Sie in Help Center und File Exchange

Produkte


Version

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by