plot graph based on given values

3 次查看（过去 30 天）
Elysi Cochin
Elysi Cochin 2022-3-26
评论： Star Strider 2022-3-30
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.

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2022-3-26
Ran in:
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 个评论
显示 10更早的评论
Elysi Cochin
Elysi Cochin 2022-3-30
Thank you sir, thats what i asked. Thank you

请先登录，再进行评论。

更多回答（1 个）

Simon Chan
Simon Chan 2022-3-26
Ran in:
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 个评论
Elysi Cochin
Elysi Cochin 2022-3-26
编辑：Elysi Cochin 2022-3-26
Sir can you please say what you have plotted? Its the histogram of cell count, correct?
Simon Chan
Simon Chan 2022-3-26
You are right, histogram of cell counts

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Line Plots 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by