How to Make a Line Graph in Excel

Create a line chart directly in Excel using a simple January–March sales example.

Set up the worksheet

Enter Month and Sales in A1 and B1. Put Jan, Feb and Mar in A2:A4, then put 120, 145 and 138 in B2:B4.

Insert the line chart

Select A1:B4, including the headers.

  1. Open Insert and choose a Line chart from the line chart menu.
  2. Use the chart title to describe the sales period. Add currency or units to the vertical axis.
  3. To compare two measures, add a column with a header, include it in the selected range, and check the legend.

Move the same data into MakeLineGraph

Copy the selected cells and use Paste data in the editor, or save the workbook and import it as XLSX. Check the worksheet and column mapping before replacing the example.

Open the editor