Analysis the columns of excel data in MATLAB and simultaneously plotting

Hello everyone,

I have transfered all my testing data into an excel sheet, for example, A1:A3 (data 1), A5:A7 (data 2), A8:10 (data 3), and so on....

I want to analyze the data 1 , data 2, data 3 and so on... in Matlab and plotting the output of each data on a single figure window for comparision.

Your help is highly appreciated in this regard.

[Sudhakar Shinde]

Can you share example data excel sheet.

Meanwhile you can look for:

https://www.mathworks.com/help/matlab/ref/xlsread.html

https://www.mathworks.com/help/matlab/creating_plots/using-high-level-plotting-functions.html

https://www.mathworks.com/help/matlab/ref/bar.html

Answer 1

[Durganshu]

Hi Rizwan:

You can use 'Import Data' tool in the HOME toolbar of MATLAB. (Instead of using 'Import Data' you can also use load(filename) or importdata(fielname) functions to load the file). Using that, you'll be able to save the data1, data2 and data3 in form of matrices in the MATLAB workspace.

Afterwards, you may use any plotting function which you can readily find on MATLAB documentation.

For simultaneous comparison of the data, make use of hold on and subplot features of the matlab plot.

You can even perform curve fitting using the 'Curve Fitting Toolbox' availabel in the APPS toolbar