How to add percent change in barplot?

Hello everyone and happy new year!

I have a barplot (average deaths per degree of temperature, 30-37oC) to which I want to add the percentage change from bar to bar. Attached you can find the excel file I am proccessing and here is the part of code that produces tha barplot.

Is there an efficient way to do so?

Thanks in advance!

PS. I am on R2019a.

Daily_Data = readtable('Daily_Data_MoT.xlsx');
idx = Daily_Data.Daily_T(:) > 30;
Daily_Data_new  = Daily_Data(idx,:);
[G, Temperature] = discretize(Daily_Data_new.Daily_T, 30:37);
d_mean = accumarray(G, Daily_Data_new.Daily_Deaths, [length(Temperature), 1], @mean);

bar(Temperature, d_mean); xlabel('T (oC)'); ylabel('Average deaths');

Answer 1

[Steve Eddins]

If you want text labels instead of a line plot (Cris' suggestion), then try this code. It gets the Bar object as the output argument from bar, and then computes the percent change and where to put the labels using the XData and YData properties of the Bar object.

b = bar(Temperature, d_mean); xlabel('T (oC)'); ylabel('Average deaths');
x = b.XData;
y = b.YData;
percent_change = 100 * diff(y) ./ y(1:end-1);
for k = 1:length(percent_change)
    text(x(k+1),y(k+1),sprintf('%0.1f%%',percent_change(k)),...
        'HorizontalAlignment','center',...
        'VerticalAlignment','bottom')
end

[Daphne PARLIARI]

That was great, thank you!

What about if I want to calculate percent change with reference to a constant temperature, e.g. 30oC?

[Steve Eddins]

reference_temp = y(1);  % 30oC in plot
percent_change = 100 * (y - reference_temp) / reference_temp;

[Daphne PARLIARI]

With this code below

x = b.XData;

y = b.YData;

reference_temp = y(1); % 30oC in plot

percent_change = 100 * (y - reference_temp) / reference_temp;

for k = 1:length(percent_change)

text(x(k+1),y(k+1),sprintf('%0.1f%%',percent_change(k)),...

'HorizontalAlignment','center',...

'VerticalAlignment','bottom')

end

I am getting the Error: Index exceeds the number of array elements (8).

Answer 2

[Cris LaPierre]

You can add a line plot to a bar plot. Just use the hold on command.

If you need it to be on a separate Y scale, look at this example

• Combine Line and Bar Charts Using Different Y Axes

[Daphne PARLIARI]

Thank you Cris! Since I am not very experienced in MatLab, Steve's answer was easier for me to comprehend...