If you have some rather confusing data, consider using the 'Moving average' option to help you get a better picture of the overall trend. This option is best for data sets in which points more or less fall in a straight line. It only displays the most suitable line, or the rate at which something is increasing or decreasing.

This is the basic option and probably the easiest way for someone to read the chart to understand. Clicking on it will show you all available trend lines.

If you click on the small arrow that appears next to the Trendlines section in the Chart Elements menu, you will find that there are several different types available, as well as the 'More Options …' box. Use the Trendline button to add any type of road you want. Go to the Layout tab and find the 'Analysis' group on the right.ģ. The toolbar title above will now say 'Chart Tools'.Ģ. If you are still using Excel 2010 (support for this version will end in 2020), then there is a little difference:ġ. By default, Excel inserts a linear trendline. Click the + button at the top right of the chart - labeled 'Chart Elements' when you hover over it.Ĥ. Select the chart you want to add the trendline to.Ģ. If you use the latest version of Excel (2013, 2016, 2019), creating trendlines is extremely simple:ġ. How to choose the appropriate trend line: Check the value of R squared.

Power trend lines in excel 2016