Problem with loop to construct graph
1 view (last 30 days)
Show older comments
Currently I am working on constructing a bar graph for my data (file as attached). But I encountered some problem while trying to rearrange the the data into specific categories. I would like to plot one figure for each position, which means
for Figure 1 ( x position), there will be 3 categories a) x <0.3 cm b) 0.3 cm<x<0.5 cm c) x >0.5 cm
and classify all the data in the column max-x (excel file as attached, sheet name : Book1) into these 3 categories. I already tried using hist and binranges command but it does not work.
2 Comments
Accepted Answer
Mostafa
on 27 Oct 2016
Edited: Mostafa
on 27 Oct 2016
%Reading the data from sheet 1, cells B2 to D8
dataMat = xlsread('Book1.xlsx', 1, 'B2:D8', 'basic');
%Get sum of numbers that satisfy the conditions for x-column
x1 = sum(dataMat(:, 1) < 0.3);
x2 = sum((dataMat(:, 1) > 0.3) & (dataMat(:, 1) < 0.5));
x3 = sum(dataMat(:, 1) > 0.5);
%Draw, bar width = 0.5 for readability
bar([x1 x2 x3], 0.5);
%Rename x-axis to be more meaningful
set(gca,'XTickLabel',{'x < 0.3', '0.3 < x < 0.5', 'x > 0.5'});
0 Comments
More Answers (0)
See Also
Categories
Find more on Bar Plots 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!