Name a graph with the title of the sheets of excel
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponse acceptée
Tommy
le 4 Juin 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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur 2-D and 3-D Plots dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!