ploting data excel to matlab

1 次查看（过去 30 天）

显示更早的评论

joni nababan 2020-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506557-ploting-data-excel-to-matlab

评论： Adam 2020-2-24

采纳的回答： darova

hello, please help

i have problem to plot a data excel to matlab. how i can fix it?

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

joni nababan 2020-2-20

在 MATLAB Online 中打开

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

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 2020-2-24

my problem is to make a graph of the data that is in excel

请先登录，再进行评论。

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

采纳的回答

darova 2020-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506557-ploting-data-excel-to-matlab#answer_416519

在 MATLAB Online 中打开

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)

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

joni nababan 2020-2-24

yes

Adam 2020-2-24

在 MATLAB Online 中打开

doc colon

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

Community Treasure Hunt

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

Start Hunting!

Translated by

ploting data excel to matlab

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

ploting data excel to matlab

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

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

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