The frequency is plotted against the midpoint of each group and the points are then joined by straight lines. Example Using the above table, the midpoints are 32.5, 37.7, 42.5, 47.5 and 52.5.

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).