x

How to Connect the Dots on a Graph Using Excel

by Jeremy Radey

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.

Select the type of line chart that meets your preference.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

More Articles