Once you enter the command, a cursor will appear on the graph allowing you to click the area you wish to apply the label.

To create this article, volunteer authors worked to edit and improve it over time.

MATLAB allows you to easily customize, label, and analyze graphs, giving you more freedom than the traditional Excel graph.

Writing Data From Matlab To Excel How To Import And

This instruction set will teach you how to import and graph excel data in MATLAB.

To make the process of importing and graphing data easier, clear any text in the command window with the command clc.

The pathway for the folder typically is: C:Usersyour account nameDocumentsMATLAB.

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.

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).

Enter the command var xlsread(filename, xlrange); into the command window for each column you want to import.

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)).

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)).

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)).

If you wish to enter text near your graphed lines, enter the command gtext(text).

Writing Data From Matlab To Excel For Mac