One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

How to make a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

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.

A graph or chart makes the spreadsheet productive and attractively visualizes the data. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets.