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

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.

Answer 1

[BhaTTa]

Please refer to this MATLAB Answer : https://www.mathworks.com/matlabcentral/answers/810390