Learn how to insert a diagonal line to a cell in Microsoft Excel and Google Sheets using the Border feature, Drawing tool, Sparkline function, etc.

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.

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.