How to make a Line Graph in Microsoft Excel 2007 1 Enter the data in the worksheet 2 Make sure not to leave blank rows or columns when entering the data 3 Once the dada has been entered Drag select with the mouse to highlight all the cells which contain the data to be included in the graph Looking at the above diagram Click on the Insert tab Click on the chart category to open the drop down list of available graph types placing the mouse pointer over a graph type will bring the description of the graph Preferably use Line with Markers 3 Click on a graph to select it 1 2 4 Now you are ready to format your line graph When you click on a graph three tabs the Design Layout and Format tabs are added to the ribbon under the title on Chart Tools Adding a Title A Click on the Layout tab B Click on Chart Title under the Labels section C Select the third option Above Chart D Type in the title Average Precipitation mm 5 Now you should have your line graph