plot graph based on given values

2 Ansichten (letzte 30 Tage)
Elysi Cochin
Elysi Cochin am 26 Mär. 2022
Kommentiert: Star Strider am 30 Mär. 2022
I have attached the data of cell count of different type of cells. The cell count of one type cell is given in each sheets .
Based on the attached data, please can someone suggest me what kind of plot to draw with the given data for preliminary data analysis.

Akzeptierte Antwort

Star Strider
Star Strider am 26 Mär. 2022
Since they are histograms, I would do something like this —
sn = sheetnames('https://www.mathworks.com/matlabcentral/answers/uploaded_files/941694/my_excel_file.xlsx');
ns = numel(sn);
for k1 = 1:ns
figure(k1)
s{k1} = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/941694/my_excel_file.xlsx','sheet',k1);
hb = bar3(s{k1});
colormap(turbo)
for k2 = 1:numel(hb)
hb(k2).CData = hb(k2).ZData;
hb(k2).FaceColor = 'interp';
end
xlabel('x')
ylabel('y')
title(sprintf('%s',sn(k1)))
end
.
  12 Kommentare
Elysi Cochin
Elysi Cochin am 30 Mär. 2022
Thank you sir, thats what i asked. Thank you
Star Strider
Star Strider am 30 Mär. 2022
As always, my pleasure!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Simon Chan
Simon Chan am 26 Mär. 2022
May be this:
sheets = sheetnames('https://www.mathworks.com/matlabcentral/answers/uploaded_files/941694/my_excel_file.xlsx');
edges = 0:20:1400;
N = zeros(length(sheets),length(edges)-1);
for k = 1:length(sheets)
rawdata = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/941694/my_excel_file.xlsx','Sheet',sheets(k));
[N(k,:),edges] = histcounts(rawdata(:),edges);
end
s = stackedplot(diff(edges)+edges(1:end-1),N','DisplayLabels',compose('Cell #%d',1:length(sheets)));
  2 Kommentare
Elysi Cochin
Elysi Cochin am 26 Mär. 2022
Bearbeitet: Elysi Cochin am 26 Mär. 2022
Sir can you please say what you have plotted? Its the histogram of cell count, correct?
Simon Chan
Simon Chan am 26 Mär. 2022
You are right, histogram of cell counts

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Data Distribution Plots finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by