Drawing different coloured bar plots according to different conditions

3 views (last 30 days)
Hello =),
I have an excel file that looks something like this:
Participant A_1 A_2 A_3 A_4 B_1 B_2 B_3 B_4 C_1 C_2 C_3 C_4
1 1 2 1 2 35 40 23 36 0 0 1 1
2 2 1 1 1 80 54 88 25 1 1 0 0
I have 2 subjects (participants). I want to draw different bar plots for each A, B and values separately for each participant. My problem is that I need to provide different colours according to each value of A and C.
When A=1 and C=1, bar plot colour=red,
When A=1 and C=0, bar plot colour=yellow,
When A=2 and C=1, bar plot colour=green,
When A=2 and C=0, bar plot colour=black,
As a result I can have bar plots of A and C separately for each participant with coloured according to variables A and C.
I also want to bar plot variable B with the same colours provided before (according to the same colour numbers 1,2,3 and 4).
So at the end I want to have bar plots of A, B and C for each participant.
Thank you so much. :)

Accepted Answer

dpb
dpb on 25 Sep 2022
Well, let's see if I parsed this correctly...
data =[
1 1 2 1 2 35 40 23 36 0 0 1 1
2 2 1 1 1 80 54 88 25 1 1 0 0];
P=data(:,1); A=data(:,2:5), B=data(:,[2:5]+4), C=data(:,[2:5]+8);
A = 2×4
1 2 1 2 2 1 1 1
B = 2×4
35 40 23 36 80 54 88 25
%C={'y','r','k','g'}; % wished-for colors in order
NC=[1 1 0;1 0 0;0 0 0;0 1 0]; % RGB triplets to match
fnC=@(a,c) (2*(a-1)+c+1); % lookup function -- color index as FN(A,C)
hB=bar(B(1,:),'FaceColor','flat'); % draw a sample bar for one B
for i=1:size(B,2) % set bar colors to lookup value
hB.CData(i,:)=NC(fnC(A(1,i),C(1,i)),:); % have to set the CData() property w/ RGB triplet
end
ylabel('B Participant 1'); xlabel('Observation')
For the others, mimic the above -- can be written with looping constructs over Participant (row) and also with indexing into larger data array to avoid the multiple variables used here to improve legibility.
You can set any choice of RGB triplets to not be quite so garish as suits...
  3 Comments
Go Sugar
Go Sugar on 28 Sep 2022
It now makes sense, thank you so much for all the help.. =) Have a great day!..

Sign in to comment.

More Answers (0)

Categories

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