plot excel data in MATLAB
88 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Samer Husam
il 14 Lug 2012
Commentato: Image Analyst
il 15 Mag 2017
hi all, I have two column in excel I want to plot them by using matlab, lets say I have first column from A1-A10 and second column from B1-B10. how could I plot them in MATLAB ?? please help..
0 Commenti
Risposta accettata
Azzi Abdelmalek
il 14 Lug 2012
[v,T,vT]=xlsread('name.xls')
% 'xlsx' for exell 2007
%v: Double
%T and vT : cell
%use v containing numbers
t=v(:,1);y=v(:,2)
%if u have to plot second colone depending on first:
plot(t,y)
11 Commenti
Azzi Abdelmalek
il 18 Lug 2012
maby you are ploting num(6:16,1) wich is false,you must use num(:,1)) for the first row and num(:,2) for the second. i don't think you will have an error message
Più risposte (2)
Image Analyst
il 14 Lug 2012
Modificato: Image Analyst
il 14 Lug 2012
Use xlsread() to get the entire contents of your workbook into a cell array.
[num,txt,raw] = xlsread(filename); % From the help
Then use cell2mat or something to extract out columns into an x array and a y array.
x = cell2mat(num(1:10, 1)); % Untested
y = cell2mat(num(1:10, 2)); % Untested
Then, to plot, use
plot(x,y);
9 Commenti
Walter Roberson
il 17 Lug 2012
What does size(num) show? And please show your xlsread() command so we are sure we are talking about the same options.
andhavarapu lokesh
il 6 Mar 2017
I wanted to plot a excel sheet in matlab is there any method to scale the xaxis and yaxis commonly to all the sheets
arif hussain
il 14 Mag 2017
Hello; Can someone please help me matlab doesn't plot my excel data it show the axis only.i have attested the excel file as well.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/176181/image.png)
4 Commenti
dpb
il 15 Mag 2017
Almost certainly a spellcheck miss from a non-English speaker attempting "attached".
Image Analyst
il 15 Mag 2017
I guess that makes sense, instead of "verified". However the file was NOT attached - only a screenshot was displayed, no Excel file was attached. Use the paperclip icon.
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!