How to use default Excel data for 3d plots in MATLAB

Question

Konrad Dadej 2019-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454407-how-to-use-default-excel-data-for-3d-plots-in-matlab

回答： BhaTTa 2025-7-18

Hello.

I wonder how to transform data from Excel 3D plots in order to use them directly in MATLAB and make 3D plots in MATLAB.

For example - I got a matrix in Excel datasheet:

0 1 2 3 4

1 1 1 1 1

2 1 2 1 1

3 1 4 1 0

4 0 1 1 1

5 0 1 1 1

Where:

in first column I have x values of the potential 3d plot, starting from 2-nd row (range 1-5)

in first row I have y values of the potential 3d plot, starting from 2-nd column (range 1-4)

where the core of the matrix contains values of Z (which should be plotted in MATLAB), for the certain crosses of x and y values (axes). This is a defaulf way to plot 3d graphs in EXCEL.

Now the question is How to quickly make 3d plot directly from that matrix? I have a lot of data I the best solution for me would be just copying selected matrix into MATLAB and use come command to plot the 3d graph. My matrices are about [50x100]. Thank you.