How can I plot multiple graphs from a name column (from Excel)
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
dpb
2018-6-23
Use readtable and then splitapply with the first column ID as grouping variable. I suggest turning it into categorical variable.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Bar Plots 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!