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.
5 views (last 30 days)
Show older comments
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1257182/image.jpeg)
1 Comment
Mathieu NOE
on 10 Jan 2023
hello
I don't understand how your x,y data are organized in your excel file
Answers (1)
J. Alex Lee
on 10 Jan 2023
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 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!