how to plot maximum and minimum point from excel column?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I want to plot values of one column from excel file and mark all the minimum points in red * and maximum in green * this is what I got so far:
colA = xlsread('MinMaxVal.xlsx','B:B');
colB = xlsread('MinMaxVal.xlsx','B:B');
plot(colA);
hold on;
I defined colB to use it for marking the points.
tnx
0 comentarios
Respuestas (1)
KSSV
el 16 de Dic. de 2016
k = rand(100,1) ; % a random data, in your case your column read from excel
plot(k) ;
hold on
% plot maximum
[val,id] = max(k) ;
plot(id,k(id),'*g')
% plot minimum
[val,id] = min(k) ;
plot(id,k(id),'*r')
2 comentarios
KSSV
el 16 de Dic. de 2016
k = rand(100,1) ; % a random data, in your case your column read from excel
plot(k) ;
hold on
mu = mean(k) ;
idx = 1:length(k) ;
% plot all maximums
plot(idx(k>mu),k(k>mu),'*g')
% plot minimum
plot(idx(k<mu),k(k<mu),'*r')
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!