After selecting your chart, click on the + (plus) icon to the top right of the chart.

For trend lines specifically, we recommend using any of the 2D charts.

Click on the Insert tab in your ribbon header interface.Make sure to select headers as well to ensure that appropriate labels are created for your chart. Select the cells that contain your data.

If you don’t have a chart yet, follow these instructions to create one: Select the chart you want to add a trendline to.Use the following guidelines to add a trendline in Excel for Windows Insert a trendline in Excel for Windows In older versions of the application, some steps may be slightly different. Please note that our instructions were written for Excel 2013 and newer. Get averages, notice peaks, and drops to make better decisions in the future, or even predict what could happen based on your current data. These graphics are built into Excel, and all you have to do is follow our simple and quick tutorial to get them in your projects.Ī trendline is a useful chart element that allows you to get more insight into your data at a simple glance. Have you ever wanted to show data trends in your worksheet as a visual element? You can easily implement this in your Excel sheets with the use of trendlines.

Trend lines in excel 2016