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.
- Open Insert and choose a Line chart from the line chart menu.
- Use the chart title to describe the sales period. Add currency or units to the vertical axis.
- 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.