How to plot specific data from a imported matrix?
36 views (last 30 days)
Show older comments
Good day all,
Maybe some basic stuff, but I need support on following situation:
I used [data] = xlsread('testfile.xlsx') to import data from excel in order to create a matrix. See image.![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/786033/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/786033/image.png)
Now I would like to plot the data into a 2D-diagram. So x will the first column and y the second column. How can I separately plot for example the data from row 2 to 5 into a diagram. Many thanks for your support.
0 Comments
Accepted Answer
Dave B
on 1 Nov 2021
Edited: Dave B
on 1 Nov 2021
plot(data(:,1),data(:,2))
scatter(data(:,1),data(:,2))
You can make a line plot of rows 2 to 5
plot(data(2:5,1),data(2:5,2))
or scatter:
scatter(data(2:5,1),data(2:5,2))
Note: xlsread is not recommended. The documentaiton recommends using readtable, readmatrix, or readcell instead.
For more on indexing into arrays:
For more types of plots:
4 Comments
Dave B
on 1 Nov 2021
This is a MATLAB data type known as a cell array, it's a sort-of old fashioned way to store text. Note that the brackets aren't really part of the text, they're just indicating the way the data are stored (and how you'd access it).
Either way, strings are way better than cells (IMO) and the brackets disappear when you use strings. You can convert after reading it in:
T.Name = string(T.Name)
Or read in those chars directly as a strings:
T = readtable(yourfile, 'TextType', 'string')
More Answers (0)
See Also
Categories
Find more on Line Plots 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!