4] Add a moving average line If you feel like formatting your trendline to a moving average line, you can do so. For this, Click anywhere in the chart.

Microsoft Excel makes it easier than ever, as it provides a feature using which you can quickly add a diagonal line to a cell. Unfortunately, no such feature is available in Google Sheets as of now.

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.

Excel's functionality includes chart options you can insert to add a title directly onto a line graph, so that you don't have to insert extra text boxes or type into the cells around the graph.