Analysis the columns of excel data in MATLAB and simultaneously plotting
1 view (last 30 days)
Show older comments
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.
1 Comment
Answers (1)
Durganshu
on 12 Oct 2020
Edited: Durganshu
on 12 Oct 2020
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
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!