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.
MATLAB: Stacked bar graph with secondary y-axis line graph
graphmultiple axes
Related Solutions
Don't put the ticks every day; that's the cause for there being that many--you did it to yourself! :)
The bar() command will put ticks at convenient places automagically, if you don't like those you can then put them where want.
Use xticklabel to write something besides the tick value.
If you would convert to use datetime, you could get the day string for free...
ADDENDUM:
Sorry, got sidetracked and didn't get back when thought would/could...
It's relatively simple to use dates for the x axis and then the datetime ruler object gives you a lot of flexibility for dates --I'll also demonstrate the new(ish) MATLAB table object in lieu of the old xlsread route...
tEnersol=readtable('enerosolar.xlsx','Sheet','EneDic'); % read into a table object
tEnersol.Properties.VariableNames={'Rad','Dia'}; % assign variable names
yr=2014; % need the proper year
tEnersol.Date=datetime(yr,1,tEnersol.Dia); % and create a date column
hB=bar(tEnersol.Date,tEnersol.Rad); % bar plot against actual date
hAx=gca; % get axes handle...
xlim([datetime(2014,1,1) datetime(2015,1,1)]) % set limit to cover the full year
hAx.XAxis.TickLabelFormat='eee'; % show day of week
produced
which you'll note doesn't have the same shape as yours as it is plotted using the actual date in the data file on the x axis, not against ordinal position in the file (which is not ordered by date). This will show up if change the time format on the x-axis to 'MMM'
which illustrates the data must be from somewhere in the northern hemisphere.
I didn't worry about importing your data specifically since it appears to be a summary and not the raw data anyway.
% import bar plot data from spreadsheet
opts = detectImportOptions('data.xlsx','Range',[1 1 18 18]);data = readtable('data.xlsx',opts);% import line plot data
ave = readmatrix('data.xlsx',"Range","B20");% Create x vector of 13 months to give room for Dec bar plot
d = datetime(2019,1,1,'Format',"MMM") + calmonths(0:12);% Plot ave data
plot(d(1:end-1),ave,'k--','LineWidth',1.5)ylim([0 16])% Plot 13th month separately to give room for Dec bar plot
hold onplot(d(end),0)hold off% Turn off x-label for Jan 2020
ax = gca;ax.XTickLabel{13} = "";% Use position of current plot to determine placement of bar plots
p = get(gca,'position'); % [left bottom width height]
dx = [0 p(3).*days(diff(d))/365]; % width of each month
% Create bin data for bar plots
edges = 1:16;% plot bar plots by positioning a new axes on top of the current axis
for i = 1:length(d)-1 a = axes('Position',[p(1)+sum(dx(1:i)) p(2) .75*dx(i+1) p(4)]); b = barh(a,edges,data{:,i+1}); axis offendNot perfect, but it should be able to get your started.
Best Answer