Problem with loop to construct graph

5 views (last 30 days)
Nada Zamri
Nada Zamri on 26 Oct 2016
Edited: Mostafa on 27 Oct 2016
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
Mostafa
Mostafa on 26 Oct 2016
Edited: Mostafa on 26 Oct 2016
Can you please clarify what you want to do exactly? Do you want to draw a bar chart for the number of points according to the given criteria? For example something like this:
|
|
| |
  | |
  x<0.3   0.3<x<0.5   x>0.5
Or what exactly?

Sign in to comment.

Accepted Answer

Mostafa
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'});

More Answers (0)

Categories

Find more on App Building 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!