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. Select the appropriate line chart.

When you try to graph the values in the column, you can't graph them because Excel thinks they are strings, not numbers. To make a graph with strings in Excel, convert the strings to numbers and ...