As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Make a Line Graph in Excel: Step-by-Step Guide

Creating a line graph in Microsoft Excel allows you to visually represent data changes over time. Follow these step-by-step instructions to make a line graph.

1. Open Microsoft Excel

  • If you don't have Microsoft Excel, you can download a free trial from the Microsoft website.

2. Enter Your Data into Excel

  • Open a new spreadsheet by clicking on the “File” tab and selecting “New.”
  • Label the first column with the variable you are tracking (e.g., "Temperature").
  • Enter the corresponding values in the second column.

3. Select the Data for the Graph

  • Click on the first cell of your data.
  • Drag your mouse over the cells containing the data you want to graph.

4. Click the “Insert” Tab

  • Go to the "Insert" tab at the top of the Excel window.

5. Choose the "Line" Graph Option

  • Click on the “Line” graph option. This opens a new window for customizing your line graph.

6. Select the Data to Include

  • In the customization window, choose the data you want to include in the line graph. Deselect any unwanted data.

7. Choose Display Type

  • Choose how you want to display your data (line graph, column graph, or bar graph). For this example, select the line graph.

8. Customize Line Color

  • Choose the color for your line. In this example, select red.

9. Adjust Line Thickness

  • Choose the thickness of your line. In this example, select a thickness of 2.

10. Click the “OK” Button

  • After customizing your line graph, click the “OK” button. This inserts the line graph into your spreadsheet.

11. Resize Your Line Graph

  • Click and drag the edges of the graph to resize it.
  • Move the graph by clicking and dragging it to a new location.

12. Save Your Spreadsheet

  • Save your spreadsheet by clicking on the “File” tab and selecting “Save As.” Enter a name and choose a location, then click “Save.”

Now you have successfully created a line graph in Excel to represent your data over time.