Effacer les filtres
Effacer les filtres

How to plot a column in Excel using Matlab

8 vues (au cours des 30 derniers jours)
Khairul Afifi
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.

Réponse acceptée

Image Analyst
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-');

Plus de réponses (1)

Khairul Afifi
Khairul Afifi le 29 Nov 2014
Thank you Image Analyst. I did some modification and manage to get the graph.
  1 commentaire
Image Analyst
Image Analyst le 29 Nov 2014
You're welcome. Can you then go ahead and mark the Answer officially as "Accepted"? Thanks in advance.

Connectez-vous pour commenter.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by