How to Connect the Dots on a Graph Using Excel (4 Steps)
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.
Step 4
Select the type of line chart that meets your preference.
References
Writer Bio
Jeremy Radey has been writing professionally since 2008. He began as a research assistant, which led to his own historical research presented at the National Conference of Undergraduate Research. Radey graduated from Xavier University with a Bachelor of Arts in history and education.