How to Add Custom Trendlines to Charts for Better Analytics


show more Adding trendlines to charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Adding trendlines to charts

After you've collected a set of data, such as the number of web site visitors per month, you can make projections about how that number will change if the current trend were to continue. The math to calculate those future values isn't that hard to do, but it's really tedious. Rather than do it yourself, you can have Excel do it for you and draw a trendline in your chart to illustrate its result. So here I have a chart with some sales data, which shows values for the years 2005 through 2010. If I wanted to see, based on this data, what 2011 and beyond might look like, then I can create a trendline.

To do that, I click the chart, and then on the Chart Layout contextual tab, I can click the Trendline button, and then I select the trendline that I want to use. In this case, I want to create a linear trendline, and that will show the line that best fits the data that I have in the past. So I will click Linear Trendline, and I'll see that if everything had progressed smoothly, this...

Adding trendlines to charts
Video duration: 4m 14s 6h 32m Beginner

Viewers:

Adding trendlines to charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...