How to plot a column in Excel using Matlab
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Khairul Afifi
le 26 Nov 2014
Commenté : Image Analyst
le 29 Nov 2014
I would like to plot a column in Excel using MATLAB. There are 9 column which are column A,B,C,D,E,F,G and H and 1441 rows. I would like to plot column F with 1441 rows using Matlab. I also wish to plot column H,F and G simultaneously in a figure. I hope someone can teach me. Thank you.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/146218/image.png)
0 commentaires
Réponse acceptée
Image Analyst
le 26 Nov 2014
[numbers, txt, raw] = xlsread(filename);
colf = numbers(:, 6);
colg = numbers(:, 7);
colh = numbers(:, 8);
plot(colf, 'bo-');
hold on;
plot(colg, 'rd-');
plot(colh, 'gd-');
0 commentaires
Plus de réponses (1)
Khairul Afifi
le 29 Nov 2014
1 commentaire
Image Analyst
le 29 Nov 2014
You're welcome. Can you then go ahead and mark the Answer officially as "Accepted"? Thanks in advance.
Voir également
Catégories
En savoir plus sur Spreadsheets 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!