ploting data excel to matlab

2020 2 20
1 个回答
回答已采纳
更新时间：2020 2 24
1 次查看（30 天）

0 个投票

hello, please help
i have problem to plot a data excel to matlab. how i can fix it?

6 个评论
显示 4更早的评论 隐藏 4更早的评论

darova
darova 2020-2-20
Please post your code and data
Rik
Rik 2020-2-20
Have a read here and here. It will greatly improve your chances of getting an answer.
joni nababan
joni nababan 2020-2-20
this is the code :
try
[filename,path] = uigetfile('.xlsx')
dataExcel = xlsread(fullfile(path,filename))
try
global data;
global penghasilan;
global skor;
penghasilan = dataExcel(1:size(dataExcel,1),4)
skor = dataExcel(1:size(dataExcel,1),5)
cla
axes(handles.axes1)
plot(4:size(dataExcel,4),penghasilan,'-b.','markers',20)
grid on
legend('Data Mahasiswa')
xlabel('Mahasiswa'), ylabel('IPK')
set(gca,'xtick',0:30:size(penghasilan))
set(gca,'XtickLabel',0:30:size(penghasilan))
set(gca, 'FontSize', 6)
axes(handles.axes2)
plot(1:size(dataExcel,1)-107,skor,'-b.','markers',20)
grid on
legend('Data Mahasiswa')
xlabel('Mahasiswa'), ylabel('Skor Point')
set(gca,'xtick',0:30:size(skor))
set(gca,'XtickLabel',0:30:size(skor))
set(gca, 'FontSize', 6)
catch
msgbox({'Type data is not valid!!!';'Please insert the correct type data'})
end
catch
msgbox('insert the data')
end
please help
Adam
Adam 2020-2-20
编辑：Adam 2020-2-20
If you want help with a problem please put at least a little thought into the basics of asking a question! You had to be asked to post the code and you also haven't said what the problem is. People are not mind readers. If you have a problem you need help with the fastest way to get that is to give the people who would help you all the information available.
Jon
Jon 2020-2-20
Please explain what problem you are experiencing when you try to run your code. Also, if you select your code and the click the code button on the MATLAB Answers toolbar it will format nicely.
joni nababan
joni nababan 2020-2-24
my problem is to make a graph of the data that is in excel

请先登录，再进行评论。

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

 采纳的回答

darova
darova 2020-2-20

0 个投票

I corrected your script. Try now
[filename,path] = uigetfile('.xlsx')
dataExcel = xlsread(fullfile(path,filename))
penghasilan = dataExcel(:,4); % no need: 1:size(dataExcel,1)
skor = dataExcel(:,5);
plot(penghasilan,skor)

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by