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.

Scatter plots display individual data points, while line graphs connect these points, emphasizing trends over time. These charts are handy for identifying data correlations or deviations.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.