Name a graph with the title of the sheets of excel

1 view (last 30 days)
Hi, i hope everyone have an awesome day, i have a little problem,
i do this program and everything is "ok" , but i have so much graphs and would like to add more sheets, so ... do you know what can i add to have the title of the sheets on every graph?
xlfile = 'RamYPabHumedad.xlsx';
[~, sheets] = xlsfinfo(xlfile);
cmonths = 19;
for i = 1:cmonths %iterate over the sheets
Datenum = xlsread('RamYPabHumedad.xlsx',i);
Ramiro = Datenum(:,1);
Pablo = Datenum(:,2);
Error1 = Ramiro-Pablo;
shname = i;
value = xlsread(xlfile, shname);
figure;
plot(Ramiro, Error1,'.r');
xlabel('Ramiro');
ylabel('Error');
title(sprintf('%s', shname));
end
Thanks a lot...
Best

Accepted Answer

Tommy
Tommy on 4 Jun 2020
Perhaps like this?
xlfile = 'RamYPabHumedad.xlsx';
[~, sheets] = xlsfinfo(xlfile);
cmonths = 19;
for i = 1:cmonths %iterate over the sheets
Datenum = xlsread('RamYPabHumedad.xlsx',i);
Ramiro = Datenum(:,1);
Pablo = Datenum(:,2);
Error1 = Ramiro-Pablo;
shname = sheets{i}; % <---------------------- change here
value = xlsread(xlfile, shname);
figure;
plot(Ramiro, Error1,'.r');
xlabel('Ramiro');
ylabel('Error');
title(sprintf('%s', shname));
end

More Answers (0)

Categories

Find more on 2-D and 3-D 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!