Bar Graph from a table : Error Xdata must be unique

A B C
0 '0' 2
0 '1' 11
1 '0' 32
1 '1' 33
2 '0' 38
2 '1' 31
3 '0' 47
3 '1' 39
Want to have C on the Y axis, X axis : 0,1,2,3 , bars colored for B : 0,1.

4 Comments

Welcome to the forum @Frederick Awuah-Gyasi.
As the error message indicates, you have multiple x-values so Matlab doesn't know what to do with it, and neither do we 🙂.
Do you want 2 sets of bar plots?
Do you want to somehow combine the Y data for the same x-data groups?
Something else?
@Cris LaPierre This is what I treid b = bar(T.A,T.C) not sure how to pass in T.B.
@Adam DanzI want it grouped B grouped by A on the x axis all using the same Ydata.
A little background :This dataset is a subset of a bigger table got with this code below:
T = groupsummary(BigT,{'A','B'}) so C is the GroupCount

Sign in to comment.

 Accepted Answer

For bar, groups are created organizing the data into a matrix. The rows correspond to x, and the columns correspond to each data series. See this example.
That means you will need to do some reorganizing of the data to get it formatted correctly to create a grouped bar chart.
% Set up the problem by recreating the table.
A = [ 0 0 1 1 2 2 3 3]';
B = ['0' '1' '0' '1' '0' '1' '0' '1']';
C = [2 11 32 33 38 31 47 39]';
T = table(A,B,C);
% use sortrows to organize data in an expected format
T = sortrows(T,["B","A"]);
% extract x values, group names
x = unique(T.A);
b = unique(T.B);
% Reshape the data based on the number of unique values in A
CC = reshape(T.C,length(x),[])
CC = 4×2
2 11 32 33 38 31 47 39
% plot
bar(x,CC)
legend(b)

3 Comments

@Cris LaPierre Really do appreciate your quick response and break down of answers. Looking forwarded to be able to contribute to this forum like you.
@Frederick Awuah-Gyasi, I'm looking forward to your contributions!

Sign in to comment.

More Answers (0)

Categories

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