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

contour

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

Best Answer

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.
Related Question