File Exchange Pick of the Week

April 27th, 2007

Graphical tutorial: Import data from Excel, plot in MATLAB

I am always trying new ways of teaching people how to use MATLAB. This week, I am trying a very graphical step by step method. I have made screenshots of every click along the path while importing data from an Excel file and getting a custom graph of that data out of MATLAB. Please let me know what you think of this kind of supplemental documentation. Is this better than video, or just different? It is intended that this slideshow be printed (preferably in color) and then the user follows along with the included data file.

screenshot.JPG

By Doug Hull

09:28 UTC | Posted in Excel, Uncategorized | Permalink | 7 Comments »

You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

7 Responses to “Graphical tutorial: Import data from Excel, plot in MATLAB”

  1. Paramesh replied on April 27th, 2007 at 12:22 UTC :

    I like the videos better! More personal touch, and also clear to follow and understand.

  2. Dennis (Mike) Briggs replied on May 3rd, 2007 at 14:49 UTC :

    I think that the movie is better, because you tend to talk more and add juicy little bits of information that might take too long to type, or require too much space in a pps page.

    Your pps text is quite terse, and I never got through the tutorial. I got error msgs on subplot(212) saying that the variable DemandRudder does not exist, and there was no comment about an expression being different from a variable name (or not). In a movie, you probably would have given a couple of sentences to that issue.

  3. hafis replied on June 18th, 2007 at 23:03 UTC :

    great tutorial, keep producing more tutorials ;-)

    thank you very much.

  4. Ozlem replied on August 14th, 2008 at 10:25 UTC :

    Doug, hi, I need to read data from Excel and plot several data to another Excel file. Since I have a relatively big database, I want to use Matlab, rather than doing this manually in Excel. Can you, or anybody help please? Thank you.

  5. Doug replied on August 14th, 2008 at 10:26 UTC :

    Ozlem,

    I need more details to be able to help you. Here are several videos on the subject of Excel and MATLAB.

    http://blogs.mathworks.com/pick/category/excel/

    Doug

  6. Shanker Keshavdas replied on October 25th, 2009 at 08:11 UTC :

    You sir, are a gentleman and a scholar…

    No really, helped me out a lot. As to what is better, I guess it depends on what takes you lesser time man. I’d have to agree with the others, a video is much easier to follow.

    Thanks a lot!!!

  7. Bhuiyan replied on November 5th, 2011 at 16:59 UTC :

    Hello, I need to analyze some data for experiment. So, I read the data from .txt file into the Matlab GUI and plotted a figure in log scale. Now, How can I return the data into Excel file/Notepad from the plotted figure of Matlab GUI. Can anybody help me? or any video tutorial plz?

    Thanks….

Leave a Reply

Wrap code fragments inside <pre> tags, like this:

<pre class="code">
a = magic(3);
sum(a)
</pre>

If you have a "<" character in your code, either follow it with a space or replace it with "&lt;" (including the semicolon).
MathWorks

About

Brett & Jiro share their favorite user-contributed submissions from the File Exchange.

Subscribe


Blog Admin

These postings are the author's and don't necessarily represent the opinions of The MathWorks.