How to Create a Line Graph on Microsoft Excel

Microsoft Excel is a program you can use to analyze data. If you want to use the data you have compiled to create a line graph in Excel, it takes little time to do so. Microsoft Excel offers several types of line graphs you can choose from. After you create the line graph, you can always go back later to customize it.

...
Use Microsoft Excel to create a line graph.

Step

Open the Excel spreadsheet that has the data you want to use to create a line graph.

Step

Highlight the data you want to insert. The data must be organized by rows or columns and each row or column should be labeled.

Step

Look to the Excel ribbon and click the "Insert" tab. You can insert objects and create graphs here.

Step

Click the "Line" button located in the "Charts" section of the ribbon. A menu will drop down that has several line graphs you can choose from.

Step

Click the line graph you want to use. The line graph will appear in the center of your spreadsheet and will reflect the data you selected. You can click the outside of the graph to move it around the spreadsheet.