ploting data excel to matlab

hello, please help

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

[darova]

Please post your code and data

[Rik]

Have a read here and here. It will greatly improve your chances of getting an answer.

[joni nababan]

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]

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]

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]

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

Answer 1

[darova]

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)

[joni nababan]

what's the fucntion from size?

[darova]

YOu mean colon (:)?

[joni nababan]

yes

[Adam]

doc colon