3D surface plots 2

yaston4 · Jun 30, 2012

I am really in need of some help please.

I am new to Matlab and I need to produce a 3D surface plot using the data in excel, can anyone help me. I have posted the excel data. I have plotted the surface plot in excel, but as you can see the surface plot is not very smooth and I believe Matlab can produce a smoother plot.

I don't mind using any other software that might achieve a smoother surface plot.

Thank-you

IRstuff · Jun 30, 2012

Why not do the graph in Matlab?

Please refrain from double posting in the future.

TTFN
faq731-376

yaston4 · Jul 2, 2012

Thank you IRStuff and I apologise for the repeated post.

I have found a program on MATLAB central, which I think can help me with my problem. I wondered if anyone is having the same problem with it as I am. I open the MainGUI.m in MATLAB and run the code using (F5), but when the GUI pops up non of the GUI buttons seem to offer any commands.

http://www.mathworks.com/matlabcentral/fileexchange/28177-3d-surface-plots-from-excel-data-gui

Sorry I am new to Matlab. Thanks.

LiteYear · Jul 2, 2012

I think you're over-complicating this. Two Google searches and I've arrived at this solution:

1. Select the data (Z) values in Excel and copy them to the clipboard.

2. Enter the following in Matlab.
>> [X, Y] = meshgrid(-16:1:11, 1:1:19);
>> UIIMPORT('-pastespecial')

3. Ensure the data from Excel appears as necessary, then click Next and Finish.

4. Plot the result in Matlab using the following command.
>> surf(X, Y, A_pastespecial)

Is that what you're after?

The surf command has lots of options for changing the appearing. The mesh command might be what you want too. Check out the options here:

http://www.mathworks.com.au/help/techdoc/learn_matlab/f3-40352.html

There could be more elegant solutions too, but if quick and dirty is what you're after then I think you have it!

flash3780 · Jul 17, 2012

There are lots of ways to create such a plot. I might fill in the empty cells with zeros and save the XLS file as a CSV file.
From there, you could do:

Code:

DATA = csvread('data1.csv');
x = DATA(2:20,1);
y = DATA(1,2:29);
[xx,yy]=meshgrid(x,y);
zz = DATA(2:20,2:29)';
surf(xx,yy,zz);
grid on; axis equal; colorbar;

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

3D surface plots 2

yaston4

Mechanical

IRstuff

Aerospace

yaston4

Mechanical

LiteYear

Computer

flash3780

Mechanical

Similar threads

Part and Inventory Search

Sponsor