Not getting correct values on boxplot from imported excel data
2 views (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
Categories
Find more on Bar Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!