3D Surface Plots from Excel Data GUI
by Christopher Rouxel
12 Jul 2010
(Updated 16 Sep 2011)
Upload data from Excel and plot in 3D as a scatter plot, lsq curve fit, contour plot and others.
|
Watch this File
|
| File Information |
| Description |
Allows users to import data from excel and easily create 3D graphs in Matlab. Capable of exporting and importing Z axis matrices, exporting pictures of the graphs, automatic labeling of the surfaces, and tools for comparing two different surfaces. Can be used as a visual aid or for analysis.
This GUI can be used for many applications in many industries. For example, it can be used to simplify and streamline the design process where the characteristics of a component in a system is highly nonlinear. Using least square fit algorithm, the jumble of data becomes an intuitive 3D surface which can be rotated and the optimal size/speed/etc. can be chosen.
Go from excel to Matlab to .png pictures in a matter of minutes. |
| Acknowledgements |
The author wishes to acknowledge the following in the creation of this submission:
interpsinc.m
|
| MATLAB release |
MATLAB 7.8 (R2009a)
|
|
Tags for This File
|
| Everyone's Tags |
|
| Tags I've Applied |
|
| Add New Tags |
Please login to tag files.
|
| Updates |
| 12 Jul 2010 |
-Added variable tolerance button |
| 13 Jul 2010 |
-Created user-defined tolerance surface button
-Created custom colormap for combine surfaces button
-Rewrote "Excel Import FAQ" button |
| 13 Jul 2010 |
Shout-out to Doug's Instructional videos |
| 17 Jul 2010 |
- |
| 18 Jul 2010 |
-Updated description |
| 21 Jul 2010 |
- |
| 10 Aug 2010 |
- |
| 11 Aug 2010 |
-Title |
| 22 Sep 2010 |
- |
| 27 Oct 2010 |
-Cross-platform compatibility bug: the xlsread function works differently on Macs then on PC's. If you are using a PC and have issues, try saving the file in the .CSV format and modifying the code to look for and accept CSV data files. |
| 16 Sep 2011 |
Deleted the xlsinfo functions which made this file not work on PC's. Now everyone can use it! |
|
Contact us at files@mathworks.com