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.
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.
Drag the mouse to highlight all of the cells containing the data just entered.
Click the "Insert" tab and then click the "Line" button in the Charts group.
Select the type of line chart that meets your preference.
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.