How to Connect the Dots on a Graph Using Excel (4 Steps)

By Jeremy Radey

Line graphs help users plot changes over time.
i Jupiterimages/Photos.com/Getty Images

Excel is a spreadsheet program produced by Microsoft. Like many spreadsheet applications, Excel can both display and create graphs of data entered into a spreadsheet. There are many appearance options for graphs on the Insert tab.

Step 1

Open Microsoft Excel and enter the data you wish to graph. All x-axis data should be put in a single column and all y-axis data should be put in another single column. Data for a single point should be put in adjacent cells.

Step 2

Drag the mouse to highlight all of the cells containing the data just entered.

Step 3

Click the "Insert" tab and then click the "Line" button in the Charts group.

Step 4

Select the type of line chart that meets your preference.

×