How to Import, Graph, and Label Excel Data in MATLAB

PDF download Download Article
Learn how to import Excel data to MATLAB to take advantage of it's graphing abilities
PDF download Download Article

Whether you are an experienced MATLAB user or a novice, you may not be fully aware of MATLAB's graphing abilities. MATLAB allows you to easily customize, label, and analyze graphs, giving you more freedom than the traditional Excel graph. In order to utilize MATLAB's graphing abilities to the fullest, though, you must first understand the process for importing data. This instruction set will teach you how to import and graph excel data in MATLAB.

Things You Should Know

  • Save your Excel file as an Excel Workbook in the MATLAB folder to ensure it can be imported correctly.
  • Use the command p = plot(indep, dep1, indep, dep2) in the MATLAB command window to create a graph.
  • Enter the command grid into the MATLAB command window to add grid lines to your graph.
Part 1
Part 1 of 3:

Importing Excel Data to MATLAB

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/11\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-1.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-1.jpg","bigUrl":"\/images\/thumb\/1\/11\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-1.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-1.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To make the process of importing and graphing data easier, clear any text in the command window with the command clc .
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-2.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-2.jpg","bigUrl":"\/images\/thumb\/8\/88\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-2.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Be sure to record the name of the Excel file for later use.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7e\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-3.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-3.jpg","bigUrl":"\/images\/thumb\/7\/7e\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-3.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The pathway for the folder typically is: C:\Users\[your account name]\Documents\MATLAB . Be sure you save the file as an Excel Workbook in order to have the proper file format for the import. Once this step is complete, you should see your Excel file in the current folder section in MATLAB.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/92\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-4.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-4.jpg","bigUrl":"\/images\/thumb\/9\/92\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-4.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-4.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Identify the range of each column to be exported. The range of the column is the first cell in a column to the last cell in a column. The proper format for this range is the first cell followed by a colon followed by the last cell (I.e. “B1:B30”)
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e4\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-5.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-5.jpg","bigUrl":"\/images\/thumb\/e\/e4\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-5.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Enter the command var = xlsread('filename', 'xlrange'); into the command window for each column you want to import. In this command:
    • Var is a variable name of your choice (Example: “x” or “y”)
    • Filename is the name of your excel spreadsheet
    • Xlrange is the range of the desired column in the form “X--:X--“,with X being the letter of the column followed by the cell number.
    6. Advertisement
Part 2
Part 2 of 3:

Graphing Data in MATLAB

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/92\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-6.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-6.jpg","bigUrl":"\/images\/thumb\/9\/92\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-6.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-6.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Enter the command p = plot(indep, dep1, indep, dep2) in the command window. In this command, indep is the independent variable and dep1 and dep2 are the dependent variables. If you wish to graph more than two dependent variables, follow the same format and add a dep3 variable. If you wish to graph only one dependent variable, only graph the first pair of x and y values (Example: plot(x, y1)).
Part 3
Part 3 of 3:

Customizing Graphs in MATLAB

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f7\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-7.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-7.jpg","bigUrl":"\/images\/thumb\/f\/f7\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-7.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-7.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Enter the command set(p,’color’,’[Desired Color]’); into the command window to change all the graphed lines to the same color. In this command, p is a reference to the variable you set your plot equal to in step 6. If you wish to change the color of only one line enter set(p(x),’color’,’[Desired Color]’); into the command line. The x in p(x) is the number that corresponds to the order that the lines are plotted in (Example: y1 = p(1), y2 = p(2)).
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b8\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-8.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-8.jpg","bigUrl":"\/images\/thumb\/b\/b8\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-8.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-8.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Enter the command set(p,’LineStyle’,’style’); into the command window to change all of the graphed lines to the same style. If you wish to change the style of one line only, enter the command set(p(x),’LineStyle’,’style’); into the command line. In this command, the x in p(x) corresponds to the number in which the lines were graphed (Example: y1 = p(1), y2 = p(2)). Common line styles include:
    • dashed lines= '--'
    • dotted lines = ':'
    • solid line = '-'
    • dash-dot line = '-.'
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-9.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-9.jpg","bigUrl":"\/images\/thumb\/b\/b9\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-9.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-9.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    To label the x-axis, enter the command xlabel(‘text’) in the command window. To label the y-axis, enter the command ylabel(‘text’) in the command window.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/15\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-10.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-10.jpg","bigUrl":"\/images\/thumb\/1\/15\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-10.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-10.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Enter the command title(‘text’) in the command window. The title will display at the top of your graph.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-11.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-11.jpg","bigUrl":"\/images\/thumb\/3\/3b\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-11.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-11.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you wish to enter text near your graphed lines, enter the command gtext(‘text’) . Once you enter the command, a cursor will appear on the graph allowing you to click the area you wish to apply the label. The label can be put anywhere in the graph space.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e9\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-12.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-12.jpg","bigUrl":"\/images\/thumb\/e\/e9\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-12.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-12.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you wish to put grid lines in your plot for easier reading, enter the command grid into the command window. Entering the command again will remove the grid lines.
  7. 7
    Save your graph. Click file on upper right hand side of the MATLAB graph screen followed by save as in the menu. Save the graph to the desired location.
    8. Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-13.jpg\/v4-460px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-13.jpg","bigUrl":"\/images\/thumb\/6\/60\/Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-13.jpg\/v4-728px-Import%2C-Graph%2C-and-Label-Excel-Data-in-MATLAB-Step-13.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}


Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Find Horizontal Asymptotes: Rules for Rational Functions
      How to
      Find the Y Intercept
      How to
      Create a Graph in Google Sheets
      How to
      Create a Graph in Excel
      How to
      Graph an Equation
      How to
      Graph Sine and Cosine Functions
      How to
      Graph a Parabola
      How Do You Find the Period of a Function?
      How to
      Read a Psychrometric Chart
      2 Easy Ways to Make a Chart with Two Y Axes in Excel
      How to
      Find the X Intercept
      How to
      Make a Line Graph From Data in Microsoft Excel
      How to
      Graph a Quadratic Equation
      How to
      Graph Linear Equations
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 79,018 times.

      Is this article up to date?

      Advertisement