I have data points for different x and y points in excel and am trying to create a 3D contour plot of this data

For two different experiments I took data at various x and y coordinates in an excel spreedsheet. I need to plot this data into a 3d contour plot in MATLAB. I used [x,y] = meshgrid(2:0.5:26, 2:0.5:18) to establish my axis but I dont know how to plot each data point at the corresponding x and y value. Excel sheet is attached

[Adam Danz]

Check out the examples in the documentation that use the same approach.

https://www.mathworks.com/help/matlab/ref/contour.html#mw_96c26d96-2a02-4e5f-a593-6d711e9e1083

Answer 1

[Star Strider]

I have absolutely no idea what you want.

Try this:

D = xlsread('excel for aerolab3.xlsx');
y1 = D(2:12, 2:end);
y2 = D(16:26, 2:end);

xv = D(1,2:end);
yv = D(2:12,1);

figure
mesh(xv, yv, y1)
hold on
contour3(xv, yv, y1, '-k', 'LineWidth',1.5)
hold off
grid on

figure
mesh(xv, yv, y2)
hold on
contour3(xv, yv, y2, '-k', 'LineWidth',1.5)
hold off
grid on

Experiment to get the result you want.

[Stephen Mixon]

I measured data points at different x and y values. I need to plot these data points on a contour plot at those x and y values.

[Adam Danz]

https://www.mathworks.com/help/matlab/ref/contour.html#mw_96c26d96-2a02-4e5f-a593-6d711e9e1083

[Star Strider]

@Stephen Mixon — My code provides the 3D contour plots you said you wanted.

For 2D contour plots, this works:

figure
contour(xv, yv, y1)

figure
contour(xv, yv, y2)

Also consider using the contourf function.