how to plot maximum and minimum point from excel column?

1 vue (au cours des 30 derniers jours)
Tsvi Weiss
Tsvi Weiss le 16 Déc 2016
Commenté : KSSV le 16 Déc 2016
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

Réponses (1)

KSSV
KSSV le 16 Déc 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 commentaires
Tsvi Weiss
Tsvi Weiss le 16 Déc 2016
tnx i tried it and it show me only one min and one max points how can i find the entire local min and max points of the values and plot them on the same line? picture added of the all the points marked in green *the excel table has 2 columns (A: date B:value of the date) and 96 rows of values of each date (2 to 97)
KSSV
KSSV le 16 Déc 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')

Connectez-vous pour commenter.

Catégories

En savoir plus sur Data Import from MATLAB 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!

Translated by