Matlab Extracting X and Y coordinates??

8 views (last 30 days)
Kevin
Kevin on 12 Aug 2014
Commented: Michael Haderlein on 13 Aug 2014
Hi,
I have created an xy plot in Matlab but I was wondering if there is a quick and easy way of extracting all x and y points so I can recreate the graph on Excel?
Thanks, Kevin

Answers (2)

Image Analyst
Image Analyst on 12 Aug 2014
There is nothing to "extract" since you already have them - you must have them if you plotted them. So just use xlswrite or activex to send them to Excel. Then have a plot already set up in Excel to look at some fixed range, or else have a macro embedded in the workbook that can do it, or else (hardest) use ActiveX to create one from scratch. If you use ActiveX, record a macro in Excel first and look at the course code to see what ActiveX commands you need to call.

Michael Haderlein
Michael Haderlein on 12 Aug 2014
Some quick and dirty method is the variable editor. Double click on your x/y variables in the Workspace window and you will get the content shown in a spreadsheet. From there, you can simply copy-paste it into Excel.
  2 Comments
Kevin
Kevin on 13 Aug 2014
Thanks for your comment. I have tried this but the workspace only saves the most recent entry and I need to use all x and y points. Any other ideas? Thanks.
Michael Haderlein
Michael Haderlein on 13 Aug 2014
let's assume you have created your plot with
plot(x,y)
then double click on the x variable in the workspace, highlight all the values which appear and copy them to Excel. Do the same with the y values. What do you mean with most recent entry?

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!