How to plot a column in Excel using Matlab

22 次查看（过去 30 天）
Khairul Afifi
Khairul Afifi 2014-11-26
评论： Image Analyst 2014-11-29
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.

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2014-11-26
[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-');

更多回答（1 个）

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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Bar Plots 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by