how to export plot from matlab2021a to excel using Mac

Does anyone knows how to export plot from matlab2021a to excel using Mac

Answer 1

[Suraj Kumar]

Hi @cheng li,

To export a plot from MATLAB 2021a to Excel on a Mac, you can refer to the following steps and attached code snippets:

1. You can save the plot as an image file (e.g., PNG, JPEG) using the saveas function in MATLAB.

x = 0:0.1:10;
y = sin(x);
plot(x, y);
saveas(gcf, 'myPlot.png');

2. You can manually insert the saved image into an Excel spreadsheet by following the below mentioned steps:

• Open Excel and navigate to the worksheet where you want to insert the plot.
• Go to the Insert tab in Excel.
• Click on Pictures and choose Picture from File.
• Locate and select the image file you saved from MATLAB

3. If you also need to export the data used in the plot to excel, you can use the writematrix function in MATLAB to export the data.

data = [x', y'];
writematrix(data, 'myData.xlsx');

Hope this resolves your query!