![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/226860/image.jpeg)
Stacked bar graph with secondary y-axis line graph
조회 수: 7 (최근 30일)
이전 댓글 표시
Hi,
I'm trying to achieve something like this from my excel file (attached) using MATLAB plot but I'm having a hard time. See below graph generated from excel and I wanted to regenerate it using MATLAB. Data is in excel sheet as well. Thank you.
![Capture.JPG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/226851/Capture.jpeg)
댓글 수: 0
채택된 답변
dpb
2019년 6월 29일
편집: dpb
2019년 6월 29일
[~,~,r]=xlsread('MLQ.xlsx'); % just read the spreadsheet to see what was in it...
MLQopt=detectImportOptions('MLQ.xlsx'); % will need some help to skip over the first two lines for data
MLQ=readtable('MLQ.xlsx',MLQopt); % and read the data into table
MLQ.Properties.VariableNames=cellfun(@(s)strrep(s,' ','_'),r(2,1:7),'uni',0); % get rid of blanks for v names
hB=bar(MLQ.Hour,MLQ{:,[4 3 5 6]},'stacked'); % start with the bar plot
hold on % prepare to add LH axis line
hLL=plot(MLQ.Hour,MLQ.Load,'r-','LineWidth',3); % and do so...
yyaxis right % get ready to RH axis line
hLR=plot(MLQ.Hour,MLQ.BT_SOC,'k-','LineWidth',3); % and plot them, too...
xlim([0.5 20.5])
xticks(1:20)
is the starting point for final cleanup and labelling--
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/226860/image.jpeg)
댓글 수: 4
dpb
2019년 6월 29일
Oh. If you do set x axis parameters, remember both axes need same...or to be linked (and I don't know otomh if the new(ish) yyaxis does that automagically or not.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Title에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!