plot every column in an excel sheet and the corresponding column in the second sheet in same box plot with header name as chart title.
4 次查看(过去 30 天)
显示 更早的评论
I have excel book with two sheet, both sheet have same headernames for each column, I want each column to be plotteed against it's corresponding similar colum from next sheet with the title of the chart as head name. Is there a small code to call read everycolumn and plot them?
Like below for all the columns in the sheet
1 个评论
回答(1 个)
J. Alex Lee
2023-1-10
T1 = readtable("example.xlsx","Sheet","TF off TS","NumHeaderLines",1);
T2 = readtable("example.xlsx","Sheet","No twist free off 31st TS","NumHeaderLines",1);
VarNames = T1.Properties.VariableNames;
fig = figure();
tl = tiledlayout(fig,"flow");
for k = 1:9
nexttile
x = T1.(VarNames{k});
y = T2.(VarNames{k});
c = categorical("sheet" + [ones(size(x));2*ones(size(y))]);
boxchart(c,[x;y])
title(VarNames{k})
end
fig = figure();
tl = tiledlayout(fig,"flow");
for k = 1:numel(VarNames)
nexttile
x = T1.(VarNames{k});
y = T2.(VarNames{k});
c = categorical("sheet" + [ones(size(x));2*ones(size(y))]);
boxchart(c,[x;y])
title(VarNames{k})
end
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Distribution Plots 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!