How to plot a column in Excel using Matlab

2014 11 26
2 个回答
回答已采纳
更新时间：2014 11 29
6 次查看（30 天）

0 个投票

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

0 个投票

[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

0 个投票

Thank you Image Analyst. I did some modification and manage to get the graph.

1 个评论
显示 -1更早的评论 隐藏 -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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Annotations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by