Plotting data excel into matlab
2 views (last 30 days)
Show older comments
I have two column in excel I want to plot them by using matlab, lets say I have first column from B2-B702 and second column from C2-C702. Column B is a number (age) while column C is string (tamoxifen / none treatment). I want to plot the age range data based on tamoxifen treatment or not and see the amount of patient based on the age range. How could I plot them in MATLAB ?? please help..
0 Comments
Accepted Answer
Guru
on 4 Jul 2013
Read in the data into matlab using xlsread, then plot them once they are read into the MATLAB workspace
doc xlsread
doc plot
5 Comments
Guru
on 5 Jul 2013
Either one, generally people don't like to change the raw data itself, excel in this case. So something along the lines of
y = strrep(y,'YES','1')
y = strrep(y,'NO','0')
y = str2double(y)
This would convert all instances of NO to 0, and all instance of YES to 1 so you can then plot it
More Answers (0)
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!