How can I plot multiple graphs from a name column (from Excel)
2 views (last 30 days)
Show older comments
I want to plot multiple graphs from a 3-column spreadsheet from Excel.
Data is in this format:
(name); (x-value); (y-value);
ab-1 (~ 15 rows); x; y;
ab-2 (~ 15 rows); x; y;
ab-3 (~ 15 rows); x; y;
bc-1 (~ 15 rows); x; y;
bc-2 (~ 15 rows); x; y;
bc-3 (~ 15 rows); x; y;
cd-1 (~ 15 rows); x; y;
cd-2 (~ 15 rows); x; y;
cd-3 (~ 15 rows); x; y;
...
In this example, ab-1 represents one series of values. Where there is 15 data values in this series, one value by row. I would like each plot to have three series, represented by ab-1, ab-2 and ab-3 (So ~ 45 points, this is variable). How can I create multiple 3-series plots in MATLAB, where data is discredited by text in one column?
0 Comments
Answers (1)
dpb
on 23 Jun 2018
Use readtable and then splitapply with the first column ID as grouping variable. I suggest turning it into categorical variable.
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!