how to add two trend lines in excel 2016

Well, we can always roll our own trendlines. The trendline dialog allows us to extend a trendline beyond the data in the forward or backward direction, but it doesn’t allow us to shorten a trendline (the forward and backward text boxes only accept positive values or zeros).

These trendlines are too long, each extending across the entire date range. Here’s the chart with a trendline for each series. To add a trendline to a series, right click on it and select Add Trendline. Here’s the data in a two-series timeline chart: In Category Axis Tricks for Line and Area Charts – 1 I extended this technique to show how to format parts of a line chart in distinct colors:Ī reader asked how to show two years of data on two separate lines and show a trendline for each. The article Using Trendlines in PowerPoint 2010 can also be useful or alternatively you can download chart PowerPoint templates and free presentation designs.Elsewhere in this blog I’ve showed how to Plot Two Time Series With Different Dates: You can also read the article from Microsoft Office showing how to add a trend line to a chart.

For example, in the figure below you can see a secondary trendline with using the linear regression and Forecast forward set to an additional Quarter showing the positive trend.Īdding a trend or moving average line to a chart in a PowerPoint slide following this procedure is very simple and can help you to prepare awesome forecast presentations with trend lines. In order to add a secondary trend line to a PowerPoint chart, just right click and then click Add Trendline again. You can combine different trendlines, for example if you want to use a different regression type. Besides these two options there are other regression types that you can choose: Logarithmic, Polynomial, Power, Moving Average by periods, Exponential, Linear. For example, the figure below shows a linear trend line instead of exponential.

You can change the linear regression type used to display the trend. In a sales forecast chart this is very useful to see if the trend is positive or negative. The line will be added to the existing PowerPoint chart to show the trend. This option will display a new dialog box where you can configure the moving average line or trendline.

How to add two trend lines in excel 2016