How to Connect the Dots on a Graph Using Excel

by Jeremy Radey
Jupiterimages/ 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.

Select the type of line chart that meets your preference.


Photo Credits

  • Jupiterimages/ Images

About the Author

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.

More Articles