For example, on this graph, the vertical axis goes up in steps of 2 degrees. Even though 7 degrees and 9 degrees are not shown, they are still represented between the labeled points.

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

How to Title on a Line Graph in Microsoft Excel. Microsoft Excel doesn't always provide everything you need when it generates graphs. For example, by default, your line graph doesn't included a title.

For example, click the first option, which Word simply calls "Line." Click "OK" to insert the chart and open an Excel spreadsheet. Both the chart and the spreadsheet contain random, sample data.