Not getting correct values on boxplot from imported excel data
1 view (last 30 days)
Show older comments
I am attempting to code two boxplots for comparisons on one plot. The boxplot is showing from 0 to about 12 on the left and 0 to 13 on the right no matter what I change. The data in the first column with numbers is in the 0.08 to like 0.15. The green and red are two data different data sets readSwingVec = xlsread('DigiPractice.xlsx', 'Sheet1', 'A11:AT19'); readSwingAlp = xlsread('DigiPractice.xlsx', 'Sheet1', 'A2:AT10');
SwingVec = readSwingVec(:,1); SwingAlp = readSwingAlp(:,1); SwingAandV = [SwingAlp, SwingVec];
% Plotting and formatting of plot figure(1) T = boxplot(SwingAandV); boxplot(T,'Labels',{'Alpl/fl','Vecko'})
2 Comments
Cris LaPierre
on 29 Apr 2022
Without your data, it will be hard to say anything specific. Please attach your spreadsheet using the paperclip. Also, please copy/paste your code. That makes it easier for us to test.
Accepted Answer
Voss
on 29 Apr 2022
Edited: Voss
on 29 Apr 2022
readSwingVec = xlsread('DigiPractice.xlsx', 'Sheet1', 'A11:AT19');
readSwingAlp = xlsread('DigiPractice.xlsx', 'Sheet1', 'A2:AT10');
SwingVec = readSwingVec(:,1);
SwingAlp = readSwingAlp(:,1);
SwingAandV = [SwingAlp, SwingVec];
% Plotting and formatting of plot
figure(1)
T = boxplot(SwingAandV,'Labels',{'Alpl/fl','Vecko'});
whos T
T
ishandle(T)
% When you do this, instead of having the effect of updating the boxplot
% you just created, you are calling boxplot on the line handles of the
% previous boxplot (which happen to have numeric values around 10~23 in
% this case), which deletes the previous boxplot and makes a new one from
% those numbers. Instead, include the Labels in the previous boxplot call.
boxplot(T,'Labels',{'Alpl/fl','Vecko'})
0 Comments
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!