How to Connect the Dots on a Graph Using Excel

Line graphs help users plot changes over time.

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.

Instructions

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.

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

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

4. Select the type of line chart that meets your preference.

References

• GilsMethod; How to Create a Line Chart in Excel 2010; Gilberto J Perera
• Addictive Tips: Office Excel 2010 Charts And Graphs